Quick Query Help

[cvansickle]

Hello and Sorry to bother..



I think this is an easy solution, but I am very much a newbie and have 'brain freezes' alot

I have a payroll database with a number of employees in it.

The Data has the employee listed on separate rows for each JobCode.

Example:

John Doe Hours 8
John Doe OT Hours 2
John Hoe Vacation Hours 6

I need to do a query that shows John Doe on a single row with the Hours (Column 3) , OT Hours (Column 4), Vacation Hours (Column 5), Total Hours (Column 6)

In my head it seems easy enough.. But like I mentioned - Brain Freeze

Thanks for the HELP


Chad

[CJ_London]

investigate using a crosstab query

row header - group by employee name
row header - sum the hours column for total hours
column header - group by name of your hours column
value - sum the hours column (again)


note the row headers will appear in the first columns - so your total will be column 2

this should not matter because you can correct this in your form or report layout