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? 4
Expression Problems in Query 4
ms access product function 2
Aggregate calculations on calculated query fields? 6
union query issue 3
Help with SUM syntax 8
subquery in group by query 3
Invalid use of null in query expression 3

Top