Grouping Expression

  • Thread starter Thread starter acss
  • Start date Start date
A

acss

I have a field with a calculation for percent and i am trying to use this
query in a report yet when i run the report is receive an error "Cannot have
Aggregate function in group by clause (sum([InvAmt]*0.03)). Can this be
resolved within the query or report?

Thanks
 
When you try to sum a field that has been grouped it doesn't work. Put a
textbox in the footer of the report and put as its control souce
=sum([invamt]*.03)
 
The query is being used in a report which contains 4 countries and two
accounts per country. My report groups these two accounts and provides a sum
total and what i need is that sumtotal and add another field that subtracts 3
percent from the subtotal per account. Any suggestions?

Golfinray said:
When you try to sum a field that has been grouped it doesn't work. Put a
textbox in the footer of the report and put as its control souce
=sum([invamt]*.03)

acss said:
I have a field with a calculation for percent and i am trying to use this
query in a report yet when i run the report is receive an error "Cannot have
Aggregate function in group by clause (sum([InvAmt]*0.03)). Can this be
resolved within the query or report?

Thanks
Click to expand...
Click to expand...
 
Back
Top