need help writing a cross tab

[Jim W]

I have a table which contains several configurations for equipment. I'm trying to write a query to sort the data for a simple conparison but am having great difficulties getting it to work. The data is stored in the format below.

System Config1 Config2 Config3 Config4 etc. etc

When I run my report to compare I want the layout to look like below

System1 System2 System3 etc
Config1 xxxxxx xxxxxxx xxxxxx
Config2 aaaaa aaaaa aaaaa
Config3 bbbb bbbb bbbb
etc.

Thanks for looking

Jim

 

[Jim W]

What is the confignum field for? and why do I need that?

Jim

 

[Rich]

to define which config you're referring to when entering data, config1, config2 etc.

 

[Jim W]

So then I need a second table that stores the config1 = configNum and so on

Jim

 

[maxmangion]

try searching this forum for normalization/normalisation, you will understand better why you will need the ConfigNum.

 

[Jim W]

Ok I'm getting much closer to the end result but I'm having a problem with the report. When I layout the report based on the crossTab I have Config and System. I can't seem to get the System on the top of the column as below.

-------System -- System2 <--- does not show up on the report
Config1 xxxxxx---- xxxxxx
Config2 aaaaa ---- aaaaa
Config3 bbbb------ bbbb