create table w/ fields based on common records in another field

[Guest]

i want to create a table based on values in an existing table.

the current one has fields: year, county, value

how do i make a table with fields: year, county 1, county 2, ..., county n?

thanks

 

[Guest]

Hi Casey,

In most cases creating a table with county1, county2 etc etc is a very bad
idea, the fact that you need more than 1 (ok 2 sometimes is ok) field of the
same data suggests that you should be creaqting another table of counties,
linked one to many to the table that used to house counties, or use a link
table to connect them instead.

Having said that, what problem are you having in creating a table?

TonyT..

 

[Douglas J. Steele]

Why would you want to create a denormalized table? Repeating groups
(country1, country2, ...) are extremely problematic.

Why not simply create a Cross-Tab query based on your existing table, and
use it instead?

 

[Guest]

I am new to access and dont understand the tools, etc..

the goal is to copy it into excel and make a line chart with multiple series
(each county) over time. i just was hoping i could automate this somehow
rather than copying and pasting it all.

 

[Guest]

oh- ok - the crosstabs query worked- thanks for the help guys