Using Access 2003
I have a table with some fields that don’t need to be touched and some that need to be reorganised into a single field and don’t know how to do this with SQL. I spent a good deal of time mucking about with crosstab queries but couldn't see how to make it work.
Existing Table structure:
All fields: Name, Address, Suburb, TypeA, TypeB, TypeC, TypeD
Fields to reorganise: TypeA, TypeB, TypeC and TypeD (CURRENCY)
I would like to restructure the table as follows:
All Fields: Name, Address, Suburb, Type, CountOfType
I want the Type field (TEXT) to contain one of “TypeA”, “ TypeB”, “TypeC” or “TypeD” and the CountOfType to contain the corresponding number for that type.
Thanks in advance