By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Monthly Attendance Report

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.