criteria in calculated fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my conference registration database, I need to identify those people who
have a balance due. The total amount due, total paid and balance due are all
calculated fields. I need to produce a report showing only those people who
still owe money. Using the criterion >0 in the balance due field does not
work. In fact it causes the whole query to fail. So, the only report I can
produce includes everyone whether they owe money or not. Obviously that is
not helpful to my client since there are only a few who still owe and looking
through a list of hundreds to identify those with balance due more than zero
is a pain. Can someone tell me how to limit the report to list only those
people who actually owe?
 
Do all the calculation in one query, then create another query based on the
first query, and in the second query put the criteria.
 
Works like a charm!! Thank you.
--
nhb -- nc


Ofer said:
Do all the calculation in one query, then create another query based on the
first query, and in the second query put the criteria.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top