That's just one of the many reasons why many of us "seasoned" developers shun
lookup fields. If you want to display the actual status, include the table
that stores the actual status. This would be the table with records like:
StatusID StatusTitle
1 Investigating
2 Estimating
3 On Hold
4 FUBAR ;-)

Join the appropriate numeric fields so you can include StatusTitle as the
Column Heading.
--
Duane Hookom
Microsoft Access MVP


"Andy C Matthews" wrote:

Hi there,
I'm trying to create a Crosstab query that shows a Class of Business on the
rows, Status along the columns and a total number of Projects as the values.
The trouble is, the Project Status field is a lookup from another table, so
though the Crosstab query works, along the top it shows 1, 2, 3, 4 etc as the
column headings instead of Investigating, Estimating, On Hold...etc.
I can't seem to find a way around this, can anyone help?
Many thanks