I have a query with a field containing the "Amount Due" and another with "Amount Paid" I am trying to return the :Balance Due" in a third field. All fields are in the same query "QryJobHIstory". I keep getting a syntax error and I cant seem to find the problem.
Can someone provide the proper syntax?
Jim O
As a beginner in Access I hope I have provided the necessary information, if their are any questions please let me know.
Edit:
I must have hit the wrong button and cut my title short somehow.
As a start I have the field name and beginning of the expression as follows, without the quotes, "Balance Due:[AmountDue]-[TotalPaid]".
Bookmarks