Help please!

[AndyShuter]

I have a table that contains customer records, in that table there could be say 100 records, of many could have a value that is repeated

For Example

25 = Red
25 = Blue
10 = Green
40 = Yellow

I dont know if I'm been thick here or waht, but what I would like to do is design a query that summarises to totals

Thanks


Andy

 

[Fizzio]

25 = Red
25 = Blue
10 = Green
40 = Yellow

Is this the actual data in each field or does it indicate that 25 records have Red in the field, 25 have blue etc?

 

[AndyShuter]

No it's the data, sorry

Toon Army!

 

[Fizzio]

If that is your actual data in each record, then you will have a hard time trying to summarise, total etc the field as it is non-normailsed data.

Personally, I would alter the structure to split the data into its smallest parts
'25 = Red' becomes '25' and 'Red' then you can summarise much more efficiently.

If you have no control over the data structure you will need to split (or convert) the data in the query and then summarise the calculated field.