the table I am pulling information from has only two fields, an auto-number ID field, and a text field. In the query I am trying to PivotTable, the text field correctly shows up, but when I try to work in the PivotTable, instead of the text field, I get the ID auto-number.