Query modification

I have the current query which works:

Dental Status: IIf([IMRDental Age Month] ="9","90 Days or Before DentalDue
Notification",IIf([IMRDental Age Month]="12","Annual Dental Exam
OverDue",IIf([IMRDental Age Month]="16","Mbr At Risk of 4T Profile after Next
UTA")))

However, I want to modify the query to incorporation a range for example:
= 9 and =12
=13 and ,=15
=16

Any guidance would be appreciated.

Thanks in advance.

I am concerned about your choice of using strings to represent
numbers, this soultion would work with numbers but not strings because
in Access "12" "8" because "8" "1"

Dental Status: IIf([IMRDental Age Month]16,"Mbr At Risk of 4T Profile
after Next
UTA", IIf([IMRDental Age Month]12,"Annual Dental Exam OverDue",
IIf([IMRDental Age Month] 8,"90 Days or Before DentalDue
Notification", "")))

On Feb 13, 10:41 am, CurtH wrote:
I have the current query which works:

Dental Status: IIf([IMRDental Age Month] ="9","90 Days or Before DentalDue
Notification",IIf([IMRDental Age Month]="12","Annual Dental Exam
OverDue",IIf([IMRDental Age Month]="16","Mbr At Risk of 4T Profile after Next
UTA")))

However, I want to modify the query to incorporation a range for example:

= 9 and =12
=13 and ,=15
=16

Any guidance would be appreciated.

Thanks in advance.

I'm not opposed to any suggestions you may have. I'm relatively new to
access and use what I know. The field in questions has a numeric value.
each category represents a range within that field.

"Jason Lepack" wrote:

I am concerned about your choice of using strings to represent
numbers, this soultion would work with numbers but not strings because
in Access "12" "8" because "8" "1"

Dental Status: IIf([IMRDental Age Month]16,"Mbr At Risk of 4T Profile
after Next
UTA", IIf([IMRDental Age Month]12,"Annual Dental Exam OverDue",
IIf([IMRDental Age Month] 8,"90 Days or Before DentalDue
Notification", "")))

On Feb 13, 10:41 am, CurtH wrote:
I have the current query which works:

Dental Status: IIf([IMRDental Age Month] ="9","90 Days or Before DentalDue
Notification",IIf([IMRDental Age Month]="12","Annual Dental Exam
OverDue",IIf([IMRDental Age Month]="16","Mbr At Risk of 4T Profile after Next
UTA")))

However, I want to modify the query to incorporation a range for example:

= 9 and =12
=13 and ,=15
=16

Any guidance would be appreciated.

Thanks in advance.

The field in questions has a numeric value.
Really? [IMR Dental Month]?

[IMR Dental Month], based on the fact that your initial query works,
is a text field. If you
want it to use it like a number then it should be a number.

If it is a number then the iif statement that I gave you should work
fine.

Cheers,
Jason Lepack

On Feb 13, 12:01 pm, CurtH wrote:
I'm not opposed to any suggestions you may have. I'm relatively new to
access and use what I know. The field in questions has a numeric value.
each category represents a range within that field.



"Jason Lepack" wrote:
I am concerned about your choice of using strings to represent
numbers, this soultion would work with numbers but not strings because
in Access "12" "8" because "8" "1"

Dental Status: IIf([IMRDental Age Month]16,"Mbr At Risk of 4T Profile
after Next
UTA", IIf([IMRDental Age Month]12,"Annual Dental Exam OverDue",
IIf([IMRDental Age Month] 8,"90 Days or Before DentalDue
Notification", "")))

On Feb 13, 10:41 am, CurtH wrote:
I have the current query which works:

Dental Status: IIf([IMRDental Age Month] ="9","90 Days or Before DentalDue
Notification",IIf([IMRDental Age Month]="12","Annual Dental Exam
OverDue",IIf([IMRDental Age Month]="16","Mbr At Risk of 4T Profile after Next
UTA")))

However, I want to modify the query to incorporation a range for example:

= 9 and =12
=13 and ,=15
=16

Any guidance would be appreciated.

Thanks in advance.- Hide quoted text -

- Show quoted text -