Singling out data

akh2010

Registered User.
Local time
Yesterday, 19:35
Joined
Jun 27, 2013
Messages
27
Hello!

I'm working on a query with two different types of dates: entry date and exit date. I want to create a report for people who have both entered and exited our facility. I'm trying to build a query which will exclude all information that does not have any data entered for exit data.

How do I do this?

Thank you!
 
In the criteria of that field in the query, try

Is Not Null
 
That worked! Great! Thank you so much!
 

Users who are viewing this thread

Back
Top Bottom