Help with a report

[earlsinclair]

I wonder if somebody could give me an idea on how to create the report I need. I have a database that stores time sheet of employees. So basically I have a table that contain the fields: Employee, Date, Time In, Time Out. I need to create a report from this table that will show the dates on the horizontal and the employee names on the vertical, something like this:

__________xx/xx/xxxx xx/xx/xxxx xx/xx/xxxx xx/xx/xxxx
Employee1 In: xx Out: xx In: xx Out: xx In: xx Out: xx In: xx Out: xx
Employee2 In: xx Out: xx In: xx Out: xx In: xx Out: xx In: xx Out: xx
Employee3 In: xx Out: xx In: xx Out: xx In: xx Out: xx In: xx Out: xx
Employee4 In: xx Out: xx In: xx Out: xx In: xx Out: xx In: xx Out: xx
Employee5 In: xx Out: xx In: xx Out: xx In: xx Out: xx In: xx Out: xx

This will avoid repetition of the employees names if I create a report that will group it by date. However I've been unable to create a report like that using the Access report wizard. Anybody has any idea of how I could get a report like this done?

Thanks

 

[Rich]

Have you tried a crosstab query?

 

[earlsinclair]

What's a crosstab query?

 

[directormac]

F1 is your friend!

From MS Access Help:

You use crosstab queries to calculate and restructure data for easier analysis of your data. Crosstab queries calculate a sum, average, count, or other type of total for data that is grouped by two types of information — one down the left side of the datasheet and another across the top.

There is an example is the Northwinds db.

--Reminding Mac

 

[earlsinclair]

Ok, I learned what a crosstab query is and created one the way I wanted it.

It's great but I need to enable the user to select the date interval to create this report. The way I did before with regular queries is: I created a form called Report where the user would input the date interval in two fields, one is the "from" date and the other the "to" date, and on the query, I'd put this expression on the date criteria:

Between [Forms]![Report]![From] And [Forms]![Report]![To]

And it worked like a charm. Now I tried doing this on the crosstab query, but it doesn't work. I always get this error message:

"The Microsoft Jet database engine does not recognize '[Forms]![Report]![From]' as a valid field name or expression."

Why can't it recognize now?

Or, does anybody have a better suggestion on how to enable the user to select the date interval?

Thanks