By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,827 Members | 813 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,827 IT Pros & Developers. It's quick & easy.

Bound column problem in Pivot Table MS Access 2007

P: 1
I have a table [tblBookings] with a lookup column [RoomBooked] referring to another table [tblRooms].

tblRooms has two fields, [RoomID] (Autonumber), and [RoomName]. The column I want to display is the RoomName column. If I have Bound Column = 1, and Column Count = 2, Column Widths 0cm;3cm I get the display I want.

However, if I change the Bound Column to 2, this changes the values displayed I now get column 1 values (RoomID) displaying, regardless of what I set for the Column Count and Column Widths! I thought that Bound Column worked independently from the values displayed.

The main problem is that I want to have a PivotTable view which displays the RoomName values, NOT the RoomID values whatever properties I set in the field settings on theTable or PivotTable design page, I get RoomID values.

I can of course have a value list for the RoomNames, as its a small list and not going to be edited. However, I do want to find out why it is not working!

Also, I have a currency field which refuses to display in the pivot table how it displays in table, query and form view - i.e. displays 33 for 33.00 - whatever I set in the field properties in the pivot table design.
Aug 19 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.