Hi i wonder if anyone can help me:

I have a database, with one table. I have one Form, for this one table, so that i can add, edit, ammend the data etc.

On the form i have about 25 rows, with 5 columns, each time someone wants to in this time take holiday, they would fill out the date, and the other 4 columns, i then want to 'query' everyone in the data base who has taken holiday on a certain date, so basically what im after is a custom query, whereby the user would type in the date, for which they are trying to search.

I can just about produce a simple query, but its not what im really, after, have consulted a few books, but to no avail, if there is anyone out there who could point me in the right direction, i would apreciate it!

Many thanks

Benjamjon
Version: Microsoft Office 2007