balance query

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Simply put a 0 (zero) on the criteria line under Balance. To give you a full
explanation of why that works might not be productive, because you have to
learn more about queries and underlying SQL statements. Try this, it might
work, depending on other things in the query.
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.
Click to expand...
 
Back
Top