Report and Query SUM Problem.

[kcddoorman]

You tried to execute a query that does not include the specified expression <KCD Record> as part of an aggregate function. (Error 3122)
KCD Record is my table.
I need to have a total box on my report that contains the sum of a queried field.
I tried to add an expression into the query that is its record source with this

=SUM(Nz([INTTOTAL], 0))

I get the above error.
I then tried the calculation in the report as a textbox with the same code, sans equal sign. This also returns and error in the textbox "#Error".

[NeoPa]

Can you tell us what table(s) and fields you have available?
And the SQL (particularly) you use is also necessary.