By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,968 Members | 1,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,968 IT Pros & Developers. It's quick & easy.

Query-Dates and duplication

P: n/a

I am an amateur but enjoy a good go at access! I have a small, probably
easy, query but I cant work the bloomin thing out!

I need to create a report or 5 to show how classrooms are booked (4
classrooms). I can enter the bookings etc and can produce reports to show
by month and also by classroom. Both in date order. sorted!

However I want 2 extra things really.
1- To show what classrooms are available on what days
2- To not allow an input if the date and classroom have been taken.

For example:
CR (classroom) 1 has booking for 1st Jul and 3rd July. I want a report to
show CR1 has space on the 2nd (and further obviouslly)

I also want to not be able to enter another booking for the 1st in that

The report has to show all 4 CR's.

I have created a table with the 4 CR's and a table for the booking sheet. I
also have a booking form and the reports as outlined above.

I am more than willing to send my basic attempt if this is needed.

Can anyone help?

Many thanks in advance

Jason Franks
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.