Hi,
You could use a
FORMAT function. In your case:
FORMAT (Expression, "Fixed"). Fixed format is fixed to 2 decimal places (without thousand separator).
Your SQL should look like this:
SELECT
CustomerName,
OrderNumber,
InvoiceAmount,
FORMAT ((SELECT TotalPaid FROM InvoiceList WHERE InvoiceList.InvoiceId=NewInvoice_1.InvoiceId), "Fixed") AS AmountPaid,
FORMAT ((InvoiceAmount-Total), "Fixed") AS AmountDue,
InvoiceStatus
FROM NewInvoice_1;
Refer to:
MS ACCESS: FORMAT FUNCTION (WITH STRINGS)[
^]