can a query be based on a report?

[Jody McClain]

i have created an accounts receivable report that show
each client's balance. It draws from several tables -
invoices, payments from client, payments to client, etc.
What i would like to do is include something in the report
that keeps clients that have a 'zero balance' out of the
report (thus showing only clients that owe us or that we
owe). i can't figure a way to do this - it seems that the
report has to be run to determine who has the zero
balance - can i then run a query on the report? there's
probably a much easier way of approaching this - any
suggestions are welcomed (preferrably no SQL solutions -
SQL scares me).

 

[Armen Stein]

i have created an accounts receivable report that show
each client's balance. It draws from several tables -
invoices, payments from client, payments to client, etc.
What i would like to do is include something in the report
that keeps clients that have a 'zero balance' out of the
report (thus showing only clients that owe us or that we
owe). i can't figure a way to do this - it seems that the
report has to be run to determine who has the zero
balance - can i then run a query on the report? there's
probably a much easier way of approaching this - any
suggestions are welcomed (preferrably no SQL solutions -
SQL scares me).

Hi Jody,

If you're working with Access, you'd better work on your SQLphobia
pretty soon!

In the On Format event of the section that shows the Client's
information, you can check the balance. If it's zero, set Cancel =
True. The report will run normally, but zero-balance clients will not
appear.

Hope this helps,