how to setup Array fields

[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.

 

[John Vinson]

On Sat, 31 Jul 2004 16:27:02 -0700, Mari Jackson <Mari

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.

That's not surprising, since (unless they've sneaked them in) Access
Tables do not HAVE "Array" fields; and I'd be aghast if they DID sneak
them in!

Are you sure you don't want just a one-to-many relationship between
two tables? That's a much more typical way to manage such an
operation.