|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 22nd, 2010, 05:55 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Coditional IIf with an AND/OR statement
Trying to get a query to determine a tax rate based on the province on a
record. It should look at the [Prov] field and based on what is in that field come up with the corresponding tax rate. eg IIf ([Prov]= "ON" and [Date of Service]2010/06/30,.13,.05, OR IIf ([Prov]="BC" and [Date of Service]2010/06/30,.12,.05) or something of this nature. I am not sure how to write the formula could someone help. 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode