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?