IIF Date

[sislman]

Hi,

I have table with the following columns:

[scheme] , [date of sale] , [year of account]

I want to write a query that does the following.

If [scheme name]="CARS" and [date of sale] falls between 01/12/2005 and 30/11/2006, show "2005" in [year of account]

Thanks for yur help

Regards

 

[FoFa]

Try:
YrOfAcct: IIf([scheme name]="CARS" and [date of sale] between #01/12/2005# and #30/11/2006#,"2005",[year of account])