an aggregate function error message

[newtoAccess]

Here is another one.



I am using this in a Make table query.

CopyCreditBureau01Percent: [copy_of_credit_bureau01]/[copy of credit bureau]

I am using several others that are similar and they work fine. This one and 3 after it I am getting error msg.

The error message is:

"You tried to execute a query that does not include the specified expression '[copy_of_credit_bureau01]/[copy of credit bureau]' as part of an aggregate function. "

Any suggestions on how I can fix this.

[ajetrumpet]

the error is correct. one of the other field expressions in the query contains a mathematical function of some sort. all other fields need to be in a group by clause.