Crosstab problem

[todd_taylor]

I'm using access97, and need a method of taking a crosstab
type spreadsheet, and "uncrosstab" it.

 

[[MVP] S.Clark]

Access is really a one-way street when it comes to creating crosstabs.

Once it's in that format, there is a lot of work that is required to go
back. VBA is your best bet, but multiple queries(typically one per column)
can get you "back".


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Duane Hookom]

To uncrosstab, you can use a union query.