Cross Tab Query with sub-column fields

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

Guest

Hi -

I am trying to create a cross tab query that had 3 sub-fields under 1 column.

So for example, I have a Column Heading that says Region A. And under Region
A, I will like to have 3 columns that say 'Country X, Country Y, Country Z'.
My Row headings will be unchanged.

How can this be done? I tried looking at books but none of them allows me to
do this.

Please Advise.
Thanks!
 
You can create a column heading expression of something like:
[Region] & "-" & [Country]
 
Hi Duane -

This doens't work. I am trying to create a 'checklist' type document that
checks the rows that are applicable to Country X, Y or Z.
So the column has one heading (Region), and below that cell, there are 3
sub-columns with Country X, Y and Z. Sort of like an excel spreadsheet with
the header row merged and 3 cells below.

Please let me know if my description isn't clear.
Thanks for any suggestions!

Duane Hookom said:
You can create a column heading expression of something like:
[Region] & "-" & [Country]

--
Duane Hookom
MS Access MVP


Leo said:
Hi -

I am trying to create a cross tab query that had 3 sub-fields under 1 column.

So for example, I have a Column Heading that says Region A. And under Region
A, I will like to have 3 columns that say 'Country X, Country Y, Country Z'.
My Row headings will be unchanged.

How can this be done? I tried looking at books but none of them allows me to
do this.

Please Advise.
Thanks!
Click to expand...
Click to expand...
 
When I picture a checklist, I see a form that allows users to check boxes. A
crosstab would never allow updating data. Also, I still don't see why my
suggestion wouldn't work as the record source for a report with whatever
type of headings you want.

--
Duane Hookom
MS Access MVP


Leo said:
Hi Duane -

This doens't work. I am trying to create a 'checklist' type document that
checks the rows that are applicable to Country X, Y or Z.
So the column has one heading (Region), and below that cell, there are 3
sub-columns with Country X, Y and Z. Sort of like an excel spreadsheet with
the header row merged and 3 cells below.

Please let me know if my description isn't clear.
Thanks for any suggestions!

Duane Hookom said:
You can create a column heading expression of something like:
[Region] & "-" & [Country]

--
Duane Hookom
MS Access MVP


Leo said:
Hi -

I am trying to create a cross tab query that had 3 sub-fields under 1 column.

So for example, I have a Column Heading that says Region A. And under Region
A, I will like to have 3 columns that say 'Country X, Country Y,
Click to expand...
Country
Z'.
My Row headings will be unchanged.

How can this be done? I tried looking at books but none of them allows
Click to expand...
me
to
do this.

Please Advise.
Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top