I need some assistance with creating a pivot table.
I have a recordset that is showing time postings against a job (or work order#) from our ERP system
The basic column layout for what I am looking for is as follows
Job, WorkCentre, PostYear,PostMonth, Hours.
What I would like to do is create a pivot table so that I can have one record per Job/WorkCentre with a column for each year/month combination.