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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
