Query modification

[Guest]

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.

 

[Jason Lepack]

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", "")))

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.

 

[Guest]

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.

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", "")))

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.

 

[Jason Lepack]

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

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.

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", "")))

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 -