Problem with a cross tab query

A

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
------- --------- -------
 
D

Duane Hookom

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
 
A

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;
 
G

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;

Addy said:
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;
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top