Pivot table problem 1

[Paul77fox]

Hello everyone. I'm using ms access 2010 and I have a problem with the names of the columns and rows of a pivoted table. They are 1, 2, 3....12 for month_id and 1, 2, 3.....20 for service_id, instead of jan, feb, mar... and service1, service2, service3...service20. The pivoted table is a child table and month_id and service_id are set to "lookup wizard..." for their coresponding parent tables. I think that's why I see those numbers because they are id's (autonumber). Can anyone tell me how to change this? Thank you!

 

[dhookom]

Base your pivot on a query that includes the tables with the information you want. You can also use the MonthName() function to convert 1 to January.

Duane
Hook'D on Access
MS Access MVP

 

[Paul77fox]

Thank you dhookom, I tryed the easy way but the hard way is good too