Pivot table and combo boxes

[compooper]

Hi folks!



I am trying to create a pivot table with multiple combo boxes as the rows and columns.

Problem is, the rows and columns are showing the "number" part of the field, and not the text.

What I mean is:

COMPANYID combo box refer's to the company names using a SQL statement.
SELECT [CompanyID], [CompanyShort] FROM Company ORDER BY [CompanyShort];

How do I get the actual Company Name like I have in the table/query vs the number?

[compooper]

I have a pivot table where I want to use combobox fields as my column headings.

How do I get the columns to display the column with the text data vs. the number data.

SELECT [GLACCID], [GLACCOUNT] FROM [GL-ACCOUNTS] ORDER BY [GLACCOUNT];

Its should glaccid, i want to see glaccount in the pivottable