Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / July 2004

Tip: Looking for answers? Try searching our database.

Arrays fields for the days of a month

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
- 31 Jul 2004 01:04 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.