What are the maximum number of fields you can use in a query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up an attendance record for each employee. With a field
for each day and some total columns, it will take more that one table but can
I get it all on one query?

Also what would be the formula to count things. example: If I use each
field to enter a letter such as V for vacation day and S for sick day. How
could I count the number of V's in fields JAN1 through JAN31?
 
I am trying to set up an attendance record for each employee. With a field
for each day and some total columns, it will take more that one table but can
I get it all on one query?

Also what would be the formula to count things. example: If I use each
field to enter a letter such as V for vacation day and S for sick day. How
could I count the number of V's in fields JAN1 through JAN31?
Click to expand...

No such fields SHOULD EXIST. YOur table structure is incorrect.

You're using a relational database. Use it relationally! "Fields are
expensive, records are cheap".

Consider using two tables: your Employee table, and an Attendance
table with fields like EmployeeID (link to the Employee table),
WorkDate, AbsenceReason. The last field would be NULL if the employee
is present, "S" for a sick day, "V" for vacation; if the employee is
absent there'd be no record at all, or you could have a record with
"U" for unexecused absence. Rather than 31 *fields* for January you
would have 31 *records*.

John W. Vinson[MVP]
 
Back
Top