How do I compare two date fields in a query?

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

Guest

I have two fields that contain dates. One is date required, one is date
received. I am trying to create a query that will show the items that were
received past the due date (date required). I cannot fiqure out which
operator to use or what kind of expression to build.

Any assistance will be much appreciated.
 
No, this would not go in any field, it's a complete query. To see what I
mean, open any of your own queries in design view, then select SQL View from
the View menu.

In query design view, you would enter > [DateRequired] in the criteria row
in the DateReceived column.

Modify "DateRequired" as necessary to match your field name.
 
Back
Top