can a query be based on a report?

  • Thread starter Thread starter Jody McClain
  • Start date Start date
J

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).
 
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).
Click to expand...

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,
 
Back
Top