adding up values (1 Viewer)

[skate]

I have a form based on a query that calculates the price for 6 items ([$/item]*[qty]) giving 6 different prices. For each set of 6 there is a certain number of sizes (depending on how many the user enters). Each size is a new record. What I've done is calculated the total price of all 6 items for each size (record). Now I want a total value of all items for all sizes. How do I add up all my totals from each record to get a grand total?

 

[David R]

Remember that Access understands 0, 1, or Many - not 6

It sounds like your structure might be unnormalized.

Have you considered making each size/item combination its own record, and then running a crosstab query to get the results for each size? You could run another small query then in the report footer to get the total result.