97 Access multiple IIF query
Posted on 2011-10-06
I use access 97.
I have 2 tables linked together. Tblpatients and tblevent. I need a IF-then query.
Here is the situation. If you are a medicare part A patient after 10/1/2011 and you are treated with the codes 97150 or 92508 your minutes of treatment are divided by the number of people in the group.
Here is my statement without the “after 10/1/2011”
Mins: IIf([tblpatients]![PtInsur]="medicare Part a",IIf([tblEvent]![CPT Code]="97150" And "92508",[tblEvent]![U-value]/[tblEvent]![Group],[tblEvent]![U-value]),[tblEvent]![U-value])
This statement works, but I do not know how/where to add the [tblEvent]![DateofServ]>9/30/2011
Any help appreciated.