concatenating my totals

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
 
G

GreySky

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...
 
A

administrator

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shift several columns in table 4
3 csv file to one & linking to find unique rows 0
MS ACCESS query 5
Duplicates in some fields, but not others 0
Unusual Sorting Requirement 5
Creating a query out of another query 1
how query multiple fields into one field? 1
Multiple Queries with Multiple Fields 9

Top