Search results

Thanks to all who responded. I've looked at the database very kindly sent by Mile-O & agree that it's much more systematic than my own effort! Unfortunately its drawback appears to be that, when inputting data, customer number & order number must be repeated manually for each brand qty entered...

Hi again That's correct, the data was originally input via a single form, with a quantity entry field for each brand; this has created the 106 fields. Now I've been asked to group them into about 10 brand groups, & this is the problem. thanks Rob

Hi I thought about using a Crosstab query, but it won't work as there is no common column heading in the table to generate a Value for summing, etc, the brands (all the brand columns in the table are unique). With 106 brands I would have to create the equivalent number of Crosstab queries, &...

Thanks for the reply. I am basically trying to rearrange a table. The table has been generated by Form input & has the following structure: Customer(text)|Order No(autonumber)|Brand_1|Brand_2|etc(double) There are 106 Brands & approximately 500 orders (rows). I need to link the Brands to a...

Does anyone know a way, or if there even is one, of transposing data (in the same way as Excel COpy-Paste Special-Transpose) to create a pivotted table?