Need Help with filtering?

  • Thread starter Thread starter Hill
  • Start date Start date
H

Hill

Hi;
Here is my situation. I am doing a report for the earnings of a group of
persons.
These persons can earn from station A, B, C, or D. For example you can have
a person name "Andrew" - his earning will look like this:
Station A - $20.00
Station B - $300.00
Station C - $500.00
Station D - $100.00

In my report I can generate total earning for each person in txtSum in the
footer section of a grouping. The problem is I wish to print a report with
individuals whose total earnings is > 1000.00. I thought of doing a filer on
the report, but I do not know how to apply a filer based on a text box on the
report. The report is based on a query. Any help will be appreciated. Thanks
 
Back
Top