Microsoft Access: Comparison of Two Dates

[Manny74]

Hello All,

I am trying to clean my Microsoft Access database.

I have a list of client cases we have closed.

But every now and then, my employees will overlook that a client's case is closed and will enter services on a closed case.

The data looks like this:

Chart# Customer Name Case Status Date of Closure Date of Last Service
1111 John Doe Relocated 10/4/2017 10/27/2017

So I need to create a query that will show me when a client has a service after his/her case has been closed.

Any ideas?

 

[Joe4]

In your query, under the "Date of Last Service" field, on the Criteria line, enter this:

> [Date of Closure]

Note that is these really aren't the name of your fields, you will need to adjust accordingly.

 

[Manny74]

Thanks Joe4.

When I enter [DATE CLOSED], it shows me clients who have a closure date, the same as their last service date.

I am looking for the query to show me services after the closure date......So a service date after the closure date....

 

[Joe4]

Did you miss the greater than sign in my previous post?
The criteria should look like:

[COLOR=#ff0000][B]>[/B][/COLOR] [DATE CLOSED]

The greater than sign (>) needs to be there!