bluey
Registered User.
- Local time
- Today, 15:32
- Joined
- May 14, 2002
- Messages
- 22
Access update
updated info
I have two forms one is a attendance form the other a rota form
the attendance form has the following fields
Employee no, Date1, Day name, Actual start ,Actual finish
The Rotasubform has these fields
Rota Name ,Date, Day name, Start time, Finish time
The date1 and date are linked in the relation ships.
The rota form needs to have a years worth of dates added to it for each Rota name. To many to add by hand.
They need automatically creating but only a years worth.some restrictions have to be used so not to many are made
Idealy they should be in a table but they shoud also be accessable by form.
updated info
I have two forms one is a attendance form the other a rota form
the attendance form has the following fields
Employee no, Date1, Day name, Actual start ,Actual finish
The Rotasubform has these fields
Rota Name ,Date, Day name, Start time, Finish time
The date1 and date are linked in the relation ships.
The rota form needs to have a years worth of dates added to it for each Rota name. To many to add by hand.
They need automatically creating but only a years worth.some restrictions have to be used so not to many are made
Idealy they should be in a table but they shoud also be accessable by form.
Last edited: