G
Guest
I have a query that calculates the balnce from payments made.This works fine
and displays the correct figures.My problem is I that I need to display
onlythe records that have paid and the balance is zero
My balance query is
Balance:
([TotalCost]-[ChequeRec]-[CashRec]-[PrepaymentChq]-[PrePaymentCash]) this
enterd into field.
I have been working with the criteia to gain the results i require with no
results.
I am totaly new to access and is the 1st databse i have tried.
and displays the correct figures.My problem is I that I need to display
onlythe records that have paid and the balance is zero
My balance query is
Balance:
([TotalCost]-[ChequeRec]-[CashRec]-[PrepaymentChq]-[PrePaymentCash]) this
enterd into field.
I have been working with the criteia to gain the results i require with no
results.
I am totaly new to access and is the 1st databse i have tried.