[MuchTooOld]

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

[MuchTooOld]

I have posted this and a very similar post under a similar title.

I apologise for this error - I can only put it down to old age and, unusually for me, far too much work on my plate.

This is not my usual practice and I will ensure that it doesn't happen again.