Solved

Access report ( String and Currency )

Posted on 2006-11-20
6
317 Views
Last Modified: 2013-11-28
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
Comment
Question by:Fiacre
6 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 30 total points
ID: 17985519
Hi Fiacre,
Val(Amount) should work
Check you don't have any extra spaces or Points
Good Luck!

Gary
0
 
LVL 4

Expert Comment

by:Carl2002
ID: 17985670
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
 
LVL 38

Assisted Solution

by:puppydogbuddy
puppydogbuddy earned 20 total points
ID: 17986628
Try this:

Format([Amount], "Currency")
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 3

Expert Comment

by:SimonThompson
ID: 18000072
lol or... Format(Val[Amount],"Currency") or Format(Val[Amount],"0.00")
0
 

Author Comment

by:Fiacre
ID: 18004215
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
 

Author Comment

by:Fiacre
ID: 18004229
=Format(Val(Trim([det.amt])),"Fixed")

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question