I have a table of customers business categories with 13 fields - customer, category1, category2, ....... category12. The first field contains the customers name and the next 12 contain categories, so the customer may have between 1 & 12 different categories (ie plumber, delivery driver). These category descriptions where generated from a pull down box on a form, from the table 'category'.
I need to write a query to output tabulated results with each category listing all the customers who have selected that category thus...
Architect
Smith & sons
wright ltd
Electrician
jones electrical
wright ltd
petersons
Builders
petersons
etc...
Any help would be most appreciated.
Thanks in advance guys