Arrays fields for the days of the 12 months of the year

[Mari Jackson.]

I am trying the set up a Staff Attendance/Absence
database in Access and I want to use Arrays fields for
the days of the 12 months of the year, but I unfamiliar
with using Arrays in Access. I am sure there is someone
out there who has set up this type of database using
Arrays. Also I want to put in a formula to every day the
will add 1 on to the Absence field if A is enter in that
day, is there a fast way of doing this of do I have to
put in the formula in each of the arrays fields ? So if
anyone could send me a sample database like this or
sample code I would be very grateful. My email is
(e-mail address removed) Thank.

Mari Jackson.

 

[Marc]

Hi Mari,
In case you do check back here for the answer:
You don't need arrays.
tblCourse
CourseId
CourseName
....

tblAttendee
AttendeeId
CourseId
AttendeeName
...

tblCourseRun
RunId
CourseId
StartDate
EndDate
...

tblCourseAttendance
RunId
AttendeeId
ActualDate
Present (Y/N)
...

e&oe excepted
Marc