By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,222 Members | 1,132 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,222 IT Pros & Developers. It's quick & easy.

Report and Query SUM Problem.

P: 76
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
Expand|Select|Wrap|Line Numbers
  1. =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".
Jan 8 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,660
Can you tell us what table(s) and fields you have available?
And the SQL (particularly) you use is also necessary.
Jan 9 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.