Query: taking a field and making each value a field 1

[atray04]

This is kind of a follow up to my recent post titled:
setting criteria to select information from records

I have a query that has a bunch of fields. The 2 fields that I would like to change are item and itemvalue. I would like to take each item and make it into its own field along with its corresponding value.

I hope this is possible any suggestions?

-ATray

 

[dhookom]

I think this is a crosstab query. You might get a more positive response if you would take the time to type in about 10 sample records and what you expect for a result.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[atray04]

Wow thank you that was exactly what I needed.