Comparing columns of a Query

D

David Billigmeier

I have a query that lists a Unique ID, vacation start date for that ID, and
vacation end date. Is there a way I can set up a macro, module, filter, etc.
that will only display the records where vacation end date is more than 7
days from the vacation start date? (I'm trying to determine which people
took more than 7 days vacation)
 
R

Rick B

Sure, just add a new column to your query that subtracts the two dates, then
put criteria under that new query of...
 
Top