Query matching availabilty with dates

J

Jim_Evans

I have a table of staff detail with the day of the week they are available.
A have another where a customer tells me what date he prefers.
I want to to run a query to see who's available on that day.
Then I would probably want to mark something to say they are not available if
that day was chosen again.

Thanks

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query to show where no data in a stated column 0
Querying Dates 5
Excluding results in a Query 9
Filtering records by date 2
Multiple criteria in query causes errors in report 3
Query help please 0
Date Range query design 11
add end dates to query by start date 4

Top