What does this mean?

  • Thread starter Thread starter Ejalogic12
  • Start date Start date
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])
 
I expect a sum : like
Sum([acctpaytable].[Petty Cash])

the above syntax has worked for me but not in this situation.
 
I still don't know the answer to the questions I asked. If you don't
understand my question please ask for clarification.
 
Back
Top