Problem with a cross tab query

[Addy]

hello there,

I have been spining my brains for quite some time on this one. I want
a simple cross tab query. following is a defination of my source data

Main Table: Tech Names

Tech Name - Region
-------------- - -----------

I run a query that counts the Tech names for each region so the
result is as below.

Region - Count
--------- ----------
South 55
North 50
East 65
West 10

I want the above to appear in a cross tab query like this:

South - North - East - West
------- --------- -------

 

[Guest]

The issue is probably that you need a row heading yet don't have one in your
desired output. You can "hard-code" a row heading like:

Techs:"Count Of Techs"
Row Heading

 

[Addy]

The issue is probably that you need a row heading yet don't have one in your
desired output. You can "hard-code" a row heading like:

Techs:"Count Of Techs"
Row Heading

--
Duane Hookom
Microsoft Access MVP













- Show quoted text -

That is the point. I dont want to display a row. This is what I am
currently getting

CountOfTech Name South North East West
5 5
7 7
15 15
25 25



I want to get rid of trhe CountOfTech Name row.

Here is my SQL
..
TRANSFORM qry_fsr_count.[CountOftech Name]
SELECT qry_fsr_count.[CountOftech Name]
FROM qry_fsr_count
GROUP BY qry_fsr_count.[CountOftech Name]
PIVOT qry_fsr_count.REGION;

 

[Gary Walter]

Pardon me for butting in...

you missed the quotes....

TRANSFORM qry_fsr_count.[CountOftech Name]
SELECT "Count Of Techs" As Techs
FROM qry_fsr_count
GROUP BY "Count Of Techs"
PIVOT qry_fsr_count.REGION;

The issue is probably that you need a row heading yet don't have one in
your
desired output. You can "hard-code" a row heading like:

Techs:"Count Of Techs"
Row Heading

--
Duane Hookom
Microsoft Access MVP













- Show quoted text -

That is the point. I dont want to display a row. This is what I am
currently getting

CountOfTech Name South North East West
5 5
7 7
15 15
25 25



I want to get rid of trhe CountOfTech Name row.

Here is my SQL
.
TRANSFORM qry_fsr_count.[CountOftech Name]
SELECT qry_fsr_count.[CountOftech Name]
FROM qry_fsr_count
GROUP BY qry_fsr_count.[CountOftech Name]
PIVOT qry_fsr_count.REGION;

 

[Addy]

The issue is probably that you need a row heading yet don't have one in your
desired output. You can "hard-code" a row heading like:

Techs:"Count Of Techs"
Row Heading

- Show quoted text -

That is the point. I dont want to display a row. This is what I am
currently getting

CountOfTech Name South North East West
5 5
7 7
15 15
25 25

I want to get rid of trhe CountOfTech Name row.

Here is my SQL
.
TRANSFORM qry_fsr_count.[CountOftech Name]
SELECT qry_fsr_count.[CountOftech Name]
FROM qry_fsr_count
GROUP BY qry_fsr_count.[CountOftech Name]
PIVOT qry_fsr_count.REGION;- Hide quoted text -

- Show quoted text -

Never Mind I got it to work with your earlier sugestion. Thanks alot.