syntax help

[Monzer]

Hello everyone;
I have an append query that appends all the requested records to a table for processing. Here is my question.
I have a feild called[AccType]for checking or savings, when running the append query I would like the data in feild[AccType] appear as follow:if checking=P and if savings=S.
Any help would be appreciated.
Thanks in advance

 

[flyover789]

assuming tha in AccType you have only values "checking" and "saving", nothing else and no nulls, you can use iif like:

iif([AccType] = "checking", "P", "S")

can you please post the SQL of your append Query, that you have so far? I'd try to complete it as you need it.

HTH,
fly


[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com