Sorry that my question is kind of strange but here is an example in Access SQL query:
Number: 1234567.89 and I want to show it as 123456789. That is to select all digits, including two after decimal point and show them only as digits without decimal point.
My current thinking:
SELECT format(nz(myfile.[DOLLAR AMOUNT], "000000000"), "000000000")
FROM myfile;
but it only shows 001234568, not 123456789. Please help.
Thanks,
Ning
Bookmarks