combine results query help

[mdarsot]

Hi everyone

i have field temp_a which stores data like below
20U
20A
20W


i want to display results through query however want to combine total of all 20U+20A+20W instead of outputting individually how can i do that.

 

[manmaria]

Do you want to combine the total of WHAT?
or Do you want to concatenate the fields 20U,20A,20W?

 

[gmmastros]

Read this:

thread183-1159740



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mdarsot]

Thanks

lets say there is 3 field id, counts, date.

id=> can be 20 20A 20C
count=> numeric number stored for each of above id.
date=> when the count was stored.

Feb26
20A 1000
20B 2000
20C 3000




i want to display date, count for all the combined id field. instead of displaying them individually.