This sql statement is giving me an 2

[MikeT]

This sql statement is giving me an error that goes something like "You tried to execute a query that does not include the specified expression 'field3' as part of an aggregate function."
Anybody?

SELECT SUM([field1]) AS ttlVolume,
SUM([field2]) AS ttlUnits,
field3,field4
FROM [myTable] WHERE [Date] = #3/10/2001#


Thanks

 

[TheVMan]

Try grouping by fields 3 and 4.

V

 

[Terpsfan]

SELECT field3,field4, SUM([field1]) AS ttlVolume,
SUM([field2]) AS ttlUnits
FROM [myTable] WHERE [Date] = #3/10/2001#
GROUP BY field3,field4


That should work.