- Joined
- Oct 27, 2005
- Messages
- 3
- Reaction score
- 0
I have the responsibility for keeping a record of the names of the volunteers who have volunteered to man the Visitor centre on a particular date.
The table I have created is
ID
Date
Special info
Morning
Afternoon
Basically this is just a diary.
A selection of this table will be printed off at regular intervals using a Query and then a Report The volunteers will add their names to the printed sheet for their chosen dates, morning or afternoon and the database updated on a weekly basis.
My question is this - can I automatically create the date that appears in the second field [Date] from the [ID] field or must I enter each date for each day manually.
Any other advice will be gratefully received
The table I have created is
ID
Date
Special info
Morning
Afternoon
Basically this is just a diary.
A selection of this table will be printed off at regular intervals using a Query and then a Report The volunteers will add their names to the printed sheet for their chosen dates, morning or afternoon and the database updated on a weekly basis.
My question is this - can I automatically create the date that appears in the second field [Date] from the [ID] field or must I enter each date for each day manually.
Any other advice will be gratefully received
