[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

[muckshifter]

please, stick with one thread on the same topic

http://www.pcreview.co.uk/forums/thread-4023580.php


I can't help, don't use the software.