Dsum

[Ihthisham]

Balance: (SELECT SUM([Invoice Amount]-[Payment Amount])
FROM
Invoice_Payment WHERE
Invoice_Payment.Customer ID<='001')




Table Name is Invoice_payment



Its says syntax error while running

Explain the wrong syntax pls

[Bob Fitz]

Where are you trying to use this expression

[Micron]

Agree - usage not clear.
If you use an aggregate function in sql, you have to give the result an alias name. If that is what you have in sql view, then add an alias - e.g.
SELECT SUM([Invoice Amount]-[Payment Amount]) AS Balance
FROM...

[CJ_London]

Think this is in a query view. Looks to me like there is a space before ID

[June7]

Try:

Invoice_Payment.[Customer ID]

Best to avoid spaces and punctuation/special characters in naming convention.

[Ihthisham]

Thank You ,
Best Regards

[Ihthisham]

Yes Correct,
Thank for the Advice

[Ihthisham]

Yes You are correct
Tks for the Advice

[Welshgasman]

I would hope CustomerID would also be numeric?, so no ' around the value?

[CJ_London]

The id example is ‘001’ so the preceding zeros make it text - unless there is table formatting or lookups being used