![]() Which look like this-you get the Alias you typed, not the multiplication. ![]() Just type as shown in the far right column. Note I have the unit price and number of items but not the total per invoice. If I click Run Query then I just get those fields. I'm going to add a few here, then delete some later. Then double-click a few fields to add them. In this example I'll use the invoices table. You'll get a window where you can choose which table to use. You can multiply item price by number of items to get the total.Ĭlick on the Queries icon and choose to create a query in Design view. You can also multiply items: let's say your invoice table has the item price, and number of items purchased on the invoice, but not the total per invoice. ![]() You take your one customer record and you add many invoice records together to get the total they spent on all invoices. Let's say you've got a bunch of customers with a few invoices each, and you just want to know how much each of them has spent. Here are a couple interesting things you can do. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |