Timesheet in a report

[klingoni]

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 ...

 

[PaulBricker]

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