Queries and Date Fields

[FC]

Hi,
I need to generate a query of 6 columns, where one of teh columns is the "
Date Prescribed", the data in the other columns should come up only if the
Date prescribed field is blank ( does not have a date in the form) How do I
do this?????
Thanks.
FC

 

[raskew via AccessMonster.com]

In the criteria cell of the date field:

Is Null

HTH - Bob

 

[KARL DEWEY]

Other column named Bargin --
Bargin_: IIF([Date Prescribed] Is Null, "", [Bargin])
Do same for rest of the fields.

 

[FC]

Thanks! It worked

In the criteria cell of the date field:

Is Null

HTH - Bob