Column headings in a crosstab query

[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)

 

[Guest]

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

 

[Guest]

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

 

[Guest]

That's what i meant LOL

- 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

 

[Guest]

OK next question

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

Chris

 

[JohnFol]

You can't, you'll have to do that on the form / report used to display the
results.

 

[Duane Hookom]

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.