how to write the query criteria

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

Guest

I have an effective and term date in my table. Some rows have a term date
that is one day after the effective date. How do I type the criteria to
exclude those records?
 
Val

One approach would be to open a query in design view, add the table, and add
the two date fields.

Then, in the parameter line beneath these two fields, add the criteria you
want to use to exclude. One way might be to have the [term date] be >
([effective date] + 1.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Val said:
I have an effective and term date in my table. Some rows have a term date
that is one day after the effective date. How do I type the criteria to
exclude those records?
Click to expand...


Criteria for the TermDate field:
DateAdd("d", 1, [Effective Date])
Click to expand...
 
Back
Top