Date issues

I have created a database to track employee vacation. the table I have setup has the transaction id, employee id, start date, end date and type of vacation. I need to be able to report on individual days - how may staff are on vacation but because my table is set up "start date" to "end date", I can't query on the in between days. Is there any way to break out the date ranges in order to be able to query individual days?

The easiest method would be to open your query in design view. In a blank column copy and paste this into the top row (Field)

IIf([Enter Date]>=[Start Date] And [Enter Date]<=[End Date],"True","False")

For the criteria directly below type in "True" and uncheck the Show check box to hide this field from your query. Save and close the query.

Now when you run the query, the parameter box will open to type in the date that you want to query on. Use the same format as your start and end date. The query will run and only show records that match the date you typed in.

lwells

Thanks so much...I knew there must be a way to do it, but could not for the life me figure it out!