Convert records into fields?

[psdcc]

Hi all,

I have inherited a customer table that has 33 pieces of information for each customer (250 customers). Consequently, the table ends up having around 9000 records. I would like to modify the table so that it has a single record for each customer and a field for each piece of information rather than a record.

Is there a fast way to do this? The only way I can think of doing it is creating a query for each of the 33 variables and then a "master" query that lists them all. Any help with something more efficient would be GREATLY appreciated!

psdcc

 

[dhookom]

Usually a crosstab might do this. However, we don't know where you are at and only have a vague idea of where you are going. It would help to see some sample data and identify any consistencies in the data. Also, what do you expect the final data to look like?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]