HOW DO I GROUP BY A TEXT FIELD AND SUM THE AMT..

Guest · Mar 28, 2005

MGFoster · Mar 28, 2005

aaae36 said:
HOW DO I GROUP BY A TEXT FIELD AND SUM THE AMT..

select text_column, sum(amount) as amt
from table
group by text_column

Guest · Apr 6, 2005

Hi there.. I am wanting to group by a text column that will contain more than
entry.. other fields will be different. and then my table contains an amount
field.. I am needing to sum the amount field that has the same text in
another column.... thank you and your help is greatly appreciated..

HOW DO I GROUP BY A TEXT FIELD AND SUM THE AMT..

Guest

MGFoster

Guest