balance query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

harryotoole - 30 Nov 2005 21:36 GMT

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.

Reply to this Message

OfficeDev18 - 30 Nov 2005 22:42 GMT

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
[quoted text clipped - 6 lines]
>results.
>I am totaly new to access and is the 1st databse i have tried.

Signature

Sam

Reply to this Message