K
kris
I have an 8 team rotating schedule I would like to automate a bit. Right now
I'm manually adding the date of each Sunday then adding the appropriate team
(1 - 8) into a three field table.
Example:
dateID date team
1 12/10/05 team 1
2 12/17/05 team 2 etc...
I've read some other comments in this group and have used the following
statements with no results at all. Just blank data.
date: DateAdd("d",[date],7)
date: DateAdd("d",7)
date: date()+7
Any help would be appreciated.
I'm manually adding the date of each Sunday then adding the appropriate team
(1 - 8) into a three field table.
Example:
dateID date team
1 12/10/05 team 1
2 12/17/05 team 2 etc...
I've read some other comments in this group and have used the following
statements with no results at all. Just blank data.
date: DateAdd("d",[date],7)
date: DateAdd("d",7)
date: date()+7
Any help would be appreciated.