What does this mean?

E

Ejalogic12

You tried to execute a query that doesn't include the specified expression as
part of an aggregate function or grouping.
Possible cause:

· You didn't enter an aggregate function in the TRANSFORM statement.

I am trying to send the sum of thecolumn below to a table with a field called
"OperatingExpenses". I can get 1record:
[acctpaytable].[Petty Cash]
but not the column sum.

Sum([acctpaytable].[Petty Cash])
 
E

Ejalogic12

I expect a sum : like
Sum([acctpaytable].[Petty Cash])

the above syntax has worked for me but not in this situation.
 
D

Duane Hookom

I still don't know the answer to the questions I asked. If you don't
understand my question please ask for clarification.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can't use an aggregate function in an expression? 5
union query issue 3
Sum Function Error 1
ms access product function 2
subquery in group by query 3
Aggregate calculations on calculated query fields? 8
How to fix formula to avoid divide/zero and aggregate issue. 5
How do I add a subquery and field in an aggregate query 1

Top