Hi all,
I have a list of permits. Within the table i have a 'Date from' and 'Date To'' field. A permit could last for as little as 1 day up to 1 week. I need a query to pull up data that shows all current permits that span over the current date. In short all permits that are live on that particular day. Any ideas??

Construct a query and show all relevant fields. As criteria for [Date from] and [Date to], use '<= Date()' and '>= Date()' respectively (without the quotes).

I'm assuming you fill in both fields even for a 'same day' permit.

[This message has been edited by KKilfoil (edited 02-26-2002).]

Thanks for your time!!!!!