how do i display a currency amount of 40.55 as 4055

  • Thread starter Andrew Gamvbini
  • Start date
A

Andrew Gamvbini

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

Allen Browne

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

RobFMS

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Top