Queries and Date Fields

  • Thread starter Thread starter FC
  • Start date Start date
F

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
 
Other column named Bargin --
Bargin_: IIF([Date Prescribed] Is Null, "", [Bargin])
Do same for rest of the fields.
 
Back
Top