IIF statement in Queries

[sk88]

I have a query with Age field. I would like to group them based on the age entered.

I have a code that looks like this:

AgeGroup: IIf([Age]<"65","Under 65",IIf([Age]>="65" And [Age]<"75","65-74",IIf([Age]>="75" And [Age]<"85","75-84",IIf([Age]>="85","85 and older","N/A"))))

Everything works except when the age is 100 or above. The query will show 'under 65' for those people whose age is 100 or above.



Please help.

[pbaldy]

If your age is a numeric value, you don't want quotes around them. That gives you an alphabetic test rather than a numeric test, and alphabetically 100 is less than 65.

[sk88]

If your age is a numeric value, you don't want quotes around them. That gives you an alphabetic test rather than a numeric test, and alphabetically 100 is less than 65.

You are awesome!!!! Thank you so much for the quick reply!! really appreciate your help

[pbaldy]

Happy to help!