query criteria

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

Guest

Hi

I have three colums of dates. I want access to read the dates in the colums and any date that is less than today, I want access to return the field blank. I've tried putting an expression into the criteria field, but it takes out the entire record. I want the record to stay. Can anyone help!

Msandy
 
I think you are misunderstanding the purpose of queries. Queries are used to
extract subsets or all records of a table for use in a form or report. A
query does not remove data from the table unless you execute a delete query.

If your intent is to update any date in the field that is less than today
and permanently remove the date, leaving the field permanently blank, then
you can use an update query. Bring only the date field into the query and
set the criteria to <=Date() and leave the update part blank ( or try the
word Null). This should remove the date permanently from those records that
meet your criteria leaving the rest of the record.



msandy said:
Hi,

I have three colums of dates. I want access to read the dates in the
Click to expand...
colums and any date that is less than today, I want access to return the
field blank. I've tried putting an expression into the criteria field, but
it takes out the entire record. I want the record to stay. Can anyone
help!!
 
Back
Top