New daily records for time interval

[ghacig]

Hi.

Table that assigns a descriptive value for each day for each staff member

Important Fields: ClinicDate, Staff, Description

I need to create a module that will create new records and populate them with consecutive dates for each staff, then look up the corresponding value in a separate table to find the correct description.

The lookup table is as such: tbl: StaffDays, Fields: ID (number), Day (Sunday through Saturday), Staff, Description

Thanks your help.

 

[dhookom]

What is the duration of the consecutive dates: a week, month, year? I assume the day of week of the new records will determine the Description. Does the Day field correctly store the numeric day of the week rather than the semi-useless day name?

Is there a good reason for storing the description in the new record if it is available in the StaffDays table? I wouldn't store it in the new record without a good reason.

Duane
Hook'D on Access
MS Access MVP