Crosstab Query problem

[tinker]

Hiya, Ive got a crosstab querie which i want to be used by a report. Ive got a Value field which is a numeric field, but alongside this id like a text field (so that for every value id like the corresponding text). Is this possible.
Because the corresponding text comes from a different table, maybe its possible to include the ID field and use a subform on the report to display the corresponding text using the id).

Can anybody help me,
Thanks.

 

[BLeslie88]

Well why wouldn't you just query off the 2 tables establishing a relationship and report off of the query?

If not...
TRANSFORM sum([tblPO].[TRetail]) AS data
SELECT [tblPO].[Div], [tblPO].[Dept]
FROM tblPopCFall
GROUP BY [tblPO].[Div], [tblPO].[Dept]
PIVOT [tblPO].[Period];
Transform takes vertical values in a table and sets them horizontally according to your pivot field. Is this what you wanted to do with your crosstab query?