Monthly Attendance Report

[Kevin]

Hi,

I have an attendance database that tracks when employees are present
during the week. I have a two tables that have the following
information: EmployeeTable with Fields EmployeeID, First Name and Last
Name. The Second table called Attendance has an AttendanceID,
EmployeeID, Date and Attendance Type Field (Present, Sick etc.)

I am trying to develop a report in spreadsheet format with the entire
days of the month (columns) across the page, with employee names (rows)
down the page. I want access to put X's in the days employees where
present and S's in the days where they where sick.

Thanks
Kevin

[Br]

Kevin <kz********@marcct.org> wrote:

Hi,

I have an attendance database that tracks when employees are present
during the week. I have a two tables that have the following
information: EmployeeTable with Fields EmployeeID, First Name and Last
Name. The Second table called Attendance has an AttendanceID,
EmployeeID, Date and Attendance Type Field (Present, Sick etc.)

I am trying to develop a report in spreadsheet format with the entire
days of the month (columns) across the page, with employee names
(rows) down the page. I want access to put X's in the days employees
where present and S's in the days where they where sick.

Thanks
Kevin

Sounds like a cross-tab query to me...
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response