how to write the query criteria

[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?

 

[Jeff Boyce]

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

 

[Marshall Barton]

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?

Criteria for the TermDate field:

DateAdd("d", 1, [Effective Date])