PDA

View Full Version : Currency without decial


Pat Diminico
June 2nd, 2004, 03:06 PM
I need a function to remove the decimal point not the decial place. I need to provide a data file with dollars and cents without the decimal.

Thank you

Allen Browne
June 2nd, 2004, 03:48 PM
Create a query into this table.

In the query, enter something like this into the Field row (assuming your
currency field is named Amount):
100 * [Amount]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Pat Diminico" > wrote in message
...
> I need a function to remove the decimal point not the decial place. I need
to provide a data file with dollars and cents without the decimal.
>
> Thank you

Google