how do i display a currency amount of 40.55 as 4055

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need to display then output an amount such as 40.55 but with out the
decimal point

ei 40.55 as 4055
or 36.10 as 3610

Any ideas ??
 
How about:
=100 * [MyField]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Use the Replace() function. Change the PERIOD to a NULL value.
Access 2000 and current have the function built into the VBA.
If you are using Access 97, do a search via Google.com for the Replace()
function.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
You must log in or register to reply here.

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

Sum of a range of cells that include cells using LOOKUP 3
how can i export an amount ie 4055 as 00000004055 2
label and currency textbox 5
Finding missing numbers in a sorted sequence 2
Display Access currency field correctly in Word mail merge? 1
Number Field Set As Currency 5
Loop through a record set to change a currency field based on average difference of two fields 0
Is there a way of not showing zero totals in a pivot table? 2

Back
Top