If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Crosstab query and Lookup field problem
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 |
Thread Tools | |
Display Modes | |
|
|