Check box help

[Guest]

I am creating a datbase which records attendance. on the attendance form I
want to use checboxes to record who is present. I have a table to store the
info. When I print an attendance report I want the data in my table to show
as names.(ie how do I convert the -1 in the table to a name on the report. I
hope all you axperts out there will understand what I am trying to do

Thanks

Mike

 

[Guest]

Is the attendance record to be a throwaway sheet or a permanent record?

If it is a permanent record create a table like --
Employee--
EMPCode - Autonumber
LName - text
FName - text
MI - text
Depart - Yes/No
etc -

Attendance--
EMPCode - number - long interger
WorkDate - datetime
Present - Yes/No - default -1

Set relation Employee one-to-many Attendance.

Each workday run an append query to append a record for all active (Depart =
0) personnel with current date - Date().

Use a datasheet form to list the current days records. Uncheck any employee
that is absent.

 

[Guest]

Thanks for the reply,
which has been of some help, however I would like to print a report showng
the names of those present, this is the part I can't get my head varound


Thanks
Mike

 

[Guest]

Build a query using the table with criteria for the date column -Date() and
it will pull record of the current date.

To choose your reporting date use criteria like --
[Enter date for report (12/25/05)]

Build a report and use the query as your record source.

 

[Guest]

Forgot something!
The criteria for the Present field is -1 (minus one).

An error in my earlier post --
Depart field should be a text field even if it contains numerials, not a
Yes/No field.