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!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.