Sum([Fld]) <>0

[bknight]

I'm trying to design a query such that the sum of one field does not equal zero.

I keep getting a message cannot have aggregate function in a where clause. I have put the sum in the top of the field and in the criteria, but get the same message.
So where might it be placed so that the query runs?

[HansV]

Is your query a Totals query?

It is a Totals query if the Totals button in the Show/Hide group of the Design tab of the ribbon is highlighted:

S1432.png

[bknight]

Senior moment!
Thanks