Aggregate Function Expression Error

[spyldbrat]

I am getting "YOUR QUERY DOES NOT INCLUDE THE SPECIFIED EXPRESSION 'CUSTOMER' AS PART OF AN AGGREGATE FUNCTION. After doing some research, I found I need to somehow group some or all of these columns but when I do so, I don't get the details listed for each customer. I also know the problem somehow lies with the formula. PLEASE HELP!

SELECT Aging.[Customer], Aging.[Cust ID], Aging.[PO #], Aging.[Inv #], Aging.[Ship To/Store #], Aging.[Days Aging], Aging.[Inv Amt], Aging.[Bal Due], Email_Address.[Email Address], IIf(Max([days Aging]) Between 0 And 34,"",IIf(Max([days Aging]) Between 35 And 45,"Your a deadbeat",IIf(Max([Days Aging]) Between 46 And 60,"Loser","Pay Me"))) AS Expr1


FROM Aging INNER JOIN Email_Address ON Aging.[Cust ID] = Email_Address.[Cust ID];

[Micron]

Did you make this a Totals query (sigma character on ribbon)?

You might find this easier to solve by using a query to populate a temp table with the calculations, minimum number of fields related to the calculation where at least one of them is related to the main table or query and is indexed. Then join that table to a 2nd query to get the remainder. A totals query sometimes cannot be grouped while still returning the desired records.

BTW - by temp table I do not mean one that you continually recreate.

[spyldbrat]

I am not sure what you are trying to tell me (my Access skills are very basic). I tried doing the two things below (thinking maybe this was what you were telling me I should try):

[spyldbrat]

I just rebuilt the entire query and joined the table. It seems to be working now.

Thank you.

[Micron]

referring to character at far right of image


Then there is always my friend Google who has 618,000 things to say when I asked him "ms access totals query".
Clicking that may not be the entire solution for your problem but it is a prerequisite.
You might want to post a zipped db copy if you get to struggling with this a lot. How to:

https://www.accessforums.net/showthread.php?t=70301