Currency without decial

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

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