I am trying to build a multiple column report in Access 2003. The report runs off a parameter query by dates. I need the employeeID to go across the top and the Field labels to go down along the left side. Last I need the amounts to Total at the far right. The columns will vary between 4 and 8. There are 25 fields. the data will be general numbers.

I am new at the advanced reports.

Thanks in Advance

I am trying to build a multiple column report in Access 2003. The report runs off a parameter query by dates. I need the employeeID to go across the top and the Field labels to go down along the left side. Last I need the amounts to Total at the far right. The columns will vary between 4 and 8. There are 25 fields. the data will be general numbers.

I am new at the advanced reports.

Thanks in Advance

You're welcome in Advance. :D

Are you using a crosstab query or something else?

You're welcome in Advance. :D

Are you using a crosstab query or something else?

No, a simple query. All the info is in one table.