Access query criteria

[AL]

I'm try to write a query and need some help. In a date field I want
the criteria to read:
If the date is prior to todays date then display the number 1. If the
date is today or in the future leave blank.

Any help would be appreciated.

 

[Guest]

Try:

IIf([ Field name here ]<date(),"1","")

Where [ Field name here ] enter the name of the field you wish to query.
If you are using 2 or more tables/queries you will need to change the joins
between them to give you better results or you may get results like this:
1
1

1


1
1

1
1
1

HTH
Davey