Column headings in a crosstab query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Xtab query...the Row fields come from a lookup table with an ID
number...the fields correctly display the name of the field, not the ID
number. The column fields similarly come from a lookup table (not the same
one) but headings of the columns show the ID number, not the text !! As in:

CASE TOTAL OF CASE 1 4 5 7

C/S 8 6 2
R/O FB foot 3 1
3
R/O FB finger 2 1 1


I need it to look like this:

CASE TOTAL OF CASE GA Reg LA Sed

C/S 8 6 2
R/O FB foot 3 1
3
R/O FB finger 2 1 1


....where the column headings are the actual words linked to the numbers in
the lookup table.

Anybody?

Cheers
Chris (novice)
 
You could try to join the headers table to the IDs and instead of making the
cross on the ID field, you should use the name field of the header table.

- Raoul
 
I didn't quite get what you suggested, but it gave me an idea...to create a
query including the main table and the lookup table, then making the xtab
from that....and it worked!! Thanks mate

Chris
 
That's what i meant LOL

- Raoul

Chris said:
I didn't quite get what you suggested, but it gave me an idea...to create a
query including the main table and the lookup table, then making the xtab
from that....and it worked!! Thanks mate

Chris
Click to expand...
 
OK next question

in that same xtab how do i get totals for the columns at the bottom of the
columns??

Chris
 
Or create a crosstab with must the totals and then union the two crosstabs
together.

I would use the report method as suggested by John.
 
Back
Top