I currently have a table that shows Employee Name, Date Leaving and Date Returning.
I'm wanting to see a Text Box on my main form showing who is on vacation.
How do I write this criteria in my Query ?
Mike
Vacation Requests
Competent Performer
Windows 7 32bit 
Access 2010 32bit
I currently have a table that shows Employee Name, Date Leaving and Date Returning.
I'm wanting to see a Text Box on my main form showing who is on vacation.
How do I write this criteria in my Query ?
Mike
Who is John Galt?
Windows XP Access 2007
A criteria on DateLeaving of:
<=Date()
and on DateReturning of:
>=Date()
Competent Performer
Windows 7 32bit Access 2010 32bit
Awesome, Works Perfectly.
Thank-You,
Mike
Who is John Galt?
Windows XP Access 2007
Creating a query to pull all requests that didn't request something from 1 department
Posting Permissions
Reply With Quote