Show only clients with balances

[Guest]

Can a report based on a query that shows orders with cost and payments just
print those records where the balance, which is calculated in the report, is
greater than zero?

 

[Guest]

Create the criteria in the record source of the report

SELECT TableName.cost , TableName.payments , [payments] - [cost] AS Balance
FROM TableName
WHERE ([payments] - [cost]) >0

 

[Duane Hookom]

You must be able to calculate the balance in your report's record source.

 

[Guest]

The balance calculation comes from 2 sub-reports, sales cost and payments.
There are clients with zero balance and actually with negative balances. I
just want to print the clients with a balance greater than zero.

 

[Guest]

Sorry I did not complete the picture. The balance calculation comes from 2
sub-reports, sales cost and payments. There are clients with zero balance and
actually with negative balances. I just want to print the clients with a
balance greater than zero.

Create the criteria in the record source of the report

SELECT TableName.cost , TableName.payments , [payments] - [cost] AS Balance
FROM TableName
WHERE ([payments] - [cost]) >0

--
\\// Live Long and Prosper \\//
BS"D

Can a report based on a query that shows orders with cost and payments just
print those records where the balance, which is calculated in the report, is
greater than zero?

 

[Duane Hookom]

I repeat "You must be able to calculate the balance in your report's record
source." Apparently you know how to create a query for your subreports that
list cost and payment details. Convert these record sources to totals
queries and include them in your main report's record source.