Layout in coloumns

T

tanhus

I have a report that shows the sum of hours employees works on a project in a
given period. This infomation is recieved from a time card that has the field
names of employee, project, hours and date. Right now I have it looking like
this:

Project
Employee Name
Sum Hours
Employee Name
Sum Hours
Sum Hours

However i want to make this report show the details like this

Employee Name Employee Name
Project Sum Hours Sum Hours Sum Hours

Is there some way i could make the employee names show in some coloum,
instead of rows
 
S

strive4peace

you can get what you want using a CrossTab Query

click on the Query tab in the Database window

choose the NEW command button

choose Crosstab Query Wizard

base it on your table and just follow the steps...


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
Top