P
papasmurf via AccessMonster.com
I am working on getting my vacations tables to work better.
What I am trying to do is to get a query for the 'StartDate' of staff
vacations.
There can be between 3 - 7 weeks of vacation for staff, with each week having
it own 'StartDate'.
The 'TBL-Vacation-2007' has seven 'StartDate' fields. (Start-1, Start-2, etc.)
all in date/time format.
I have created queries that will select only 'not null' entries in each
'StatDate' field, and append them together to create a table called:
table: "VacStartDate" fields: "Name" , "StartDate"
so all the data is together.
What I am now trying to do is to set up a query on this table, that a date
can be entered, and result will be any start dates seven days before and
after.
I have tried creating a "Between [input date] And [input date]" which does
work, but for work purposes I have to able to enter a date(Sunday) and be
able to find out something like
"Date()-7 and Date()+7".
But I am looking for way to input a date, something like "Date([Input Date])-
7 and Date()+7" but it does not work right.
Can anyone help me?
Thank you
What I am trying to do is to get a query for the 'StartDate' of staff
vacations.
There can be between 3 - 7 weeks of vacation for staff, with each week having
it own 'StartDate'.
The 'TBL-Vacation-2007' has seven 'StartDate' fields. (Start-1, Start-2, etc.)
all in date/time format.
I have created queries that will select only 'not null' entries in each
'StatDate' field, and append them together to create a table called:
table: "VacStartDate" fields: "Name" , "StartDate"
so all the data is together.
What I am now trying to do is to set up a query on this table, that a date
can be entered, and result will be any start dates seven days before and
after.
I have tried creating a "Between [input date] And [input date]" which does
work, but for work purposes I have to able to enter a date(Sunday) and be
able to find out something like
"Date()-7 and Date()+7".
But I am looking for way to input a date, something like "Date([Input Date])-
7 and Date()+7" but it does not work right.
Can anyone help me?
Thank you