Enter a date, find matches in 2 tables

[ajmain]

I want to be able to enter a date into my Access db, and have the fields with matching dates to be returned.
I have four employees. In the employees table, I have fields such as VacDay1, VacDay2...VacDay15.
In the orders table, for each order there are fields such as CourtDate,DeliveryDate,InspectionDate, and some others.
So I want my result to be something like this:
[Enter date:]
03/17/2001
Smith On vacation
Jones Inspection
Howard Court
Edwards Delivery
I can do basic Access queries but I don't know SQL syntax at all yet. Is it possible to do this in a basic query? If so, how?
Thanks in advance for any help/advice.

 

[MichaelRed]

The structure of the db appears, from your description, to be unsuitable for the process you are describing. Particularly the vacdayn part. SQL would - at best- be awkward with this. I would suggest that you review the subject of 'normalization' for relational database and re-structure the table(s) to be at least 'reasonably' normalized. Once that exercise is complete, it should be obvious to you.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over