Hide reords in a report

[Glynn]

I have an accounting report of all debit and credit records in customer
accounts, and need to report only those records that have generated a
negative balance in a customers account ie., anywhere within the customers'
account.

My report so far, displays all the records for each customer with 'running'
balances for the 'LedgerNo' group (each account name), and using 'Conditional
formatting' I have ascribed a 'blank' value for all positive entries, and red
formatted amounts for the few negative generated amounts.

The few 'red' negative entires are the only records I need to report - not
the hundreds of other positive records.

How can I 'hide' all the positive records, leaving only the negative
records? I could go quitely mad (if not already there), seeing my report,
but with the required negative entries lost in pages and pages irrelevant
positive entries.

Any help would be greatly appreciated.
Glynn

 

[Marshall Barton]

I have an accounting report of all debit and credit records in customer
accounts, and need to report only those records that have generated a
negative balance in a customers account ie., anywhere within the customers'
account.

My report so far, displays all the records for each customer with 'running'
balances for the 'LedgerNo' group (each account name), and using 'Conditional
formatting' I have ascribed a 'blank' value for all positive entries, and red
formatted amounts for the few negative generated amounts.

The few 'red' negative entires are the only records I need to report - not
the hundreds of other positive records.

How can I 'hide' all the positive records, leaving only the negative
records? I could go quitely mad (if not already there), seeing my report,
but with the required negative entries lost in pages and pages irrelevant
positive entries.

If you do not want records in a report (or form) then you
should base the report on a query that filters out the
unwanted records. I think all you need is to create a
simple select query with a criteria like <0 for the amount
field. Then change the report's RecordSource to the query
instead of the table.