Confused With Error Message

[pmagur01]

I have created a query to calculate the sub total, VAT and the total amount but when I run the query I get the message:

"You tried to execute a query that does not include the specified expression '[Price]*[Quantity]' as part of an aggregate function"

can someone help please?

 

[RuralGuy]

Post the SQL for the query.

 

[gemma-the-husky]

you probably have a totals query, and you have put a field in, where you have not given it a totals function (perhaps expression - which is not allowed in totals queries)