Answered by:
removing decimal in numeric output
Question

I have a query that is pulling a currency field from a database. I need the output to the table to be just 10 digits without the decimal point BUT I need the numbers to the right of the decimal. For example, if my amount is 850.75, I need my field in my table to be 0000085075. I've tried numerous ways and I either get 850.75 or 0000000850.
The query replaces the table each time so preferably I'd like to format this in the query extraction.
What am I missing?
Answers
All replies


I have a query that is pulling a currency field from a database. I need the output to the table to be just 10 digits without the decimal point BUT I need the numbers to the right of the decimal. For example, if my amount is 850.75, I need my field in my table to be 0000085075. I've tried numerous ways and I either get 850.75 or 0000000850.
Hi csmchugh,
You can make a function that first gets rid of the decimal point by multiplcation by 100. Then it formats the result with the padded zeros in front.
Imb.
