concatenating my totals

  • Thread starter Thread starter administrator
  • Start date Start date
A

administrator

Tried it ... now it's giving me

field1 30
field2 35
field3 17
field4 165

Totaltkts: (CCur([field1]+[field2]+[field3]+[field4]))

total $30,35,17,165.00
 
Try this:

ccur(field1) + ccur(field2) + ccur(field3) ...

-----Original Message-----
Tried it ... now it's giving me

field1 30
field2 35
field3 17
field4 165

Totaltkts: (CCur([field1]+[field2]+[field3]+[field4]))

total $30,35,17,165.00

-----Original Message-----
Try using an explicit conversion.

For example:

txtGrandTotal

=sum(csng([myfield]))

csng = convert single
clng = convert long
ccur = convert currency (scaled integer)

David
.
Click to expand...
.
Click to expand...
 
That worked ... you're a sweetheart. Thanks so much.
-----Original Message-----
Try this:

ccur(field1) + ccur(field2) + ccur(field3) ...

-----Original Message-----
Tried it ... now it's giving me

field1 30
field2 35
field3 17
field4 165

Totaltkts: (CCur([field1]+[field2]+[field3]+[field4]))

total $30,35,17,165.00

-----Original Message-----
Try using an explicit conversion.

For example:

txtGrandTotal

=sum(csng([myfield]))

csng = convert single
clng = convert long
ccur = convert currency (scaled integer)

David
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top