![]() You just need to figure out which are the ones who changed. You want to figure out which ones you need to talk to about new benefits because they've changed their health insurance plan from one year to another. You're the head of HR and you have thousands of employees. Let's say that you have a whole bunch of data. Note that now each customer is only listed once, and the total for their invoices is calculated. Then for the single field I selected Group in the function list, and I select Sum for the many field, as shown. So I deleted everything but those two columns. For this, you need to have just the customer ID (one) and the calculated field (many for each one customer). Now you're thinking about doing that sum thing, adding up all the totals for all the multiple invoice for each single customer. (Do this in the bottom area of the query where you do the defining, not the top where you see the results.) Or you don't even have to have them at all you can right-click on any column head and choose Delete to remove it from the query. You can unmark the checkmarks as shown and they won't show up. You don't have to have the fields you're multiplying in the query. If you want to change it you can right-click on the column heading, choose Column Format, and select a currency or number format. Note however that it is not formatted as currency in this example. 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. |