How do I compare two date fields in a query?

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

 

[Brendan Reynolds]

SELECT * FROM YourTable WHERE DateReceived > DateRequired

 

[Guest]

What field would i place this in? do I put it exactly as your wrote it?

 

[Brendan Reynolds]

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.