Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

Access report ( String and Currency )

HI,

i have a field (amount) in Access which is in STRING format (e.g. "200.1050").
How can i display it (in Access 2000 or above) with 2 dec. pl, the currency figure "200.11" ?

Details:
i tried =sum([amount]), it will actually sum up the "string".
i tried =val([amount]), it will show "#Error"
i tried =CCur([amount]), it will show "0"

Thanks all...
0
Fiacre
Asked:
Fiacre
2 Solutions
 
tbsgadiCommented:
Hi Fiacre,
Val(Amount) should work
Check you don't have any extra spaces or Points
Good Luck!

Gary
0
 
Carl2002Commented:
I agree with Gary Val(amount) is they way forward on this one. You could try val(nz(amount)).

Are you sure your amount field is text?

Carl.
0
 
puppydogbuddyCommented:
Try this:

Format([Amount], "Currency")
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
SimonThompsonCommented:
lol or... Format(Val[Amount],"Currency") or Format(Val[Amount],"0.00")
0
 
FiacreAuthor Commented:
Unable to work yet.

The detail field is "det.amt"

data type "text"
field size: 16
required: no
allow zero len: no
indexed: no

it will show "#Error", even i tried wat's suggested..."Val(amt)", Format(Val(...)), etc.
0
 
FiacreAuthor Commented:
=Format(Val(Trim([det.amt])),"Fixed")

ok, i tried the above, it's solved now.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now