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...
FiacreAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
tbsgadiConnect With a Mentor Commented:
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
 
puppydogbuddyConnect With a Mentor Commented:
Try this:

Format([Amount], "Currency")
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.