G
Guest
Hi,
I was wondering if you can help.
We run a database of rooms and events booked into them during hour slots
during the day.
A normal working week runs from 9-5 Monday to Friday, however we can book
events outside of this time (i.e. evenings and weekends).
We can currently pull off a list of events happening in a given week (Monday
- Friday) due to a query and report being set up before i started. This
basically prints off everything that is booked into the rooms between the two
dates entered. I have been asked by my manager to produce a similar report
that shows everything booked outside of normal hours (everything at the
weekend and after 5pm weekdays).
What i wanted to know was, is there an easy way to tell Access to just look
at the weekends? Is there a function i can use? Or is it going to be more
complicated than that.
Thanks,
I was wondering if you can help.
We run a database of rooms and events booked into them during hour slots
during the day.
A normal working week runs from 9-5 Monday to Friday, however we can book
events outside of this time (i.e. evenings and weekends).
We can currently pull off a list of events happening in a given week (Monday
- Friday) due to a query and report being set up before i started. This
basically prints off everything that is booked into the rooms between the two
dates entered. I have been asked by my manager to produce a similar report
that shows everything booked outside of normal hours (everything at the
weekend and after 5pm weekdays).
What i wanted to know was, is there an easy way to tell Access to just look
at the weekends? Is there a function i can use? Or is it going to be more
complicated than that.
Thanks,