Populating fields with a date range

[Samina Gordon]

Hello,

Does anyone know how to populate a set of fields with all
the dates in a certain range, e.g. I want to fill the
school holidays into a table so that they cannot be
booked against (for room bookings).

Thanks

 

[PC Datasheet]

Samina,

It sounds like you are not doing the bookings correctly!

Create a table and enter the dates of all the school holidays. Then create a
query that contains all the fields you need to do the room bookings. Put the
BookingDate in two fields of the query. In the first field, put this in the
criteria:

Not In(Select HolidayDate From TblSchoolHolidays)

In the other field put an expression that says Not Saturday or Sunday. You'll
find how to do this expression in the Help file.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel