Arrays fields for the days of a month

[Guest]

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.

 

[Duane Hookom]

I am not aware of "array fields" in Access. Use simple tables of records and
fields which are similar to arrays but you can actually see and maintain the
values in forms and reports.