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