Form Display Help

[FadingAPE]

Im trying to create a form that shows staff when people are on holiday within the space of one week. I have created a table (tblStaffHolidays)with the following headers;



HolidayID
Name
DateHolidayStarts
Duration
Team

What I want is to be able to pull up a form that shows who is on holiday for that week. I currently have the following code but it only shows whos on holiday today.

select * from [tblStaffHolidays] where DateHolidayStarts = Date()

Can anyone help me with this query please?

Many Thanks
Laura

[A S MANN]

Modify the record source to
select * from [tblStaffHolidays] where DateHolidayStarts Between Date()
And Date() -7 to show data for 7 days fron today
You can also create a query with filrered data for the week and than connect it to form as record sourse.

[FadingAPE]

Youre a star! Thank you very much!