limit query results based on 2 date fields

  • Thread starter Thread starter Sabosis
  • Start date Start date
S

Sabosis

Hello-

I have a query with "Order Date" and Date Updated" in the query
results. I only want to show records where the order date preceeded
the Date updated. How would I write this into my query?
 
Are you saying you want to see records where [OrderDate]<[DateUpdated]?

I believe you can add:
<[DateUpdated]
in the selection criterion under your [OrderDate] field...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top