Query Help!!!!!!!!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

this is the third time that I've posted and can't seem to find my 2 posts.

I have a table with three colums of dates (45 day, 75 day, and 150 day) When running a report or a query I need t
have access look at the dates and anything with a date of today or less the field needs to be left blank. I've tired to type an expression into the criteria but it takes out the entie record. I need the record to stay. Any help would be greatly appreciated

Msandy
 
Within the Access Query, Let one of your fields equal the
following:

Date2: IIf([DATE]<Date(),"",[DATE])

Don't type the expression into the criteria row.
Thats why records are being excluded.
Type this into the field row of the query.

-----Original Message-----
Hello,

this is the third time that I've posted and can't seem to find my 2 posts.

I have a table with three colums of dates (45 day, 75
Click to expand...
day, and 150 day) When running a report or a query I need
to
have access look at the dates and anything with a date of
Click to expand...
today or less the field needs to be left blank. I've
tired to type an expression into the criteria but it takes
out the entie record. I need the record to stay. Any
help would be greatly appreciated.
 
Back
Top