HELP WITH QUERY EXPRESSION

  • Thread starter Thread starter William
  • Start date Start date
W

William

I have a very simple query in which I can't the expression I created does not
work.

Column one has a list of names. In column two, I want to take the number
285,000 and divide it by a COUNT of the list of names in column one.

The formula I tried is:

Expr1: 285000/Count([ISDs]![CountColumn])

The error message when running the query is:

"Cannot have aggregate function in GROUP BY clause."

Any ideas?
 
William,

Why don't you go to the SQL view; copy that and post that here. People will
then have the detail they need to help you.

Regards

Kevin
 
Back
Top