This is probably an easy calcualtion I am overthinking...
I am trying to make a query where I am calculating the "Total Value" of each customer's order of each item for the current week. The item "my company" is selling is fish, sizes small, medium and large all at different prices. I'm not exactly sure what they mean by "Total value", but I assume I take the cost times the quantity...but then what is the difference between Total Value and total ordered (in dollar amount)? Any suggestions?

This is probably an easy calcualtion I am overthinking...
I am trying to make a query where I am calculating the "Total Value" of each customer's order of each item for the current week. The item "my company" is selling is fish, sizes small, medium and large all at different prices. I'm not exactly sure what they mean by "Total value", but I assume I take the cost times the quantity...but then what is the difference between Total Value and total ordered (in dollar amount)? Any suggestions?I have no idea what your company wants from you, but the leveling you are talking about here would probably be done with grouping in a query. Look up aggregate functions in the help menu too, and you'll gain some knowledge that'll be useful. This FAQ might also help with the query you have to write...

http://www.access-programmers.co.uk/forums/showthread.php?t=135763

sorry i wasn't more clear... but that was very helpful. thanks!