Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summation Problem

Status
Not open for further replies.

syncdba

IS-IT--Management
Nov 28, 2005
206
US
Hi,
I have a AMOUNT column which is varchar like 666.89
567.09
890.67

I converted this colum to CONVERT(money,amount) $666.89
$567.09..
Then I grouped by name
which are as CLOSED
OPEn
CONSIDERATION..
When I did the summation of AMOUNT field GROUP BY NAME field
CLOSED ######
OPEN $4578.09
CONSIDERATION $568.97
NEGOTIATION ######
WHY I'm getting ###### as SUM for CLOSED & NEGOTIATIOn
 
Try dragging the border of the field to widen it.

-LB
 
Thanks Alot! Spend lots of time on "this thing":(
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top