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
marij@eircom.net Thank.
Mari Jackson.
Duane Hookom - 31 Jul 2004 03:37 GMT
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.

Signature
Duane Hookom
MS Access MVP
> I am trying the set up a Staff Attendance/Absence
> database in Access and I want to use Arrays fields for
[quoted text clipped - 10 lines]
>
> Mari Jackson.