Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Timesheet in a report

Status
Not open for further replies.

klingoni

Technical User
Apr 30, 2002
5
CH
Hello everyone!
I'm building an application in access where employees can enter their vacation and other things. So far, so good. But in the end I want to generate a report that looks like an excel table, where each column stands for a day and each row for an employee. And then, on an employee's row all the days he's gone should be colored. You know what I mean? Finally, I want to export the report as a snapshot file, so anyone can view it without access. What's the best way to generate such a report? I've been thinking of a lot of possibilities, but up to know, I haven't found anything that could finally work...Please help me ... :)
 
Create a Crosstab query from your information and then use that as the basis for your report. Then in the Format Event for the Detail Section, put something like this:

If [ColumnName] = "EmployeeAway" Then
[ColumnName].ForeColor = vbRed
Else
[ColumnName].ForeColor = vbBlack
End If

You will have to do this for each Column in your Crosstab.

Paul
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top