Excluding Certain Records from a report

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

Guest

Hello,
I am running a report that contains monthly calls to clients. All of our
contacts are listed in one table. Is there a way to exclude certain records
from the report, of people that we will not talk to but still leave them in
the table? Thanks
 
Help IN said:
Hello,
I am running a report that contains monthly calls to clients. All of our
contacts are listed in one table. Is there a way to exclude certain
records
from the report, of people that we will not talk to but still leave them
in
the table? Thanks
Click to expand...

You would need a field in each contact record to indicate whether or not
that record should be included in the report. Then, you can open the report
from a form with DoCmd.OpenReport (for example, in the Click event of a
command button) and pass a Where condition based on that field, for example:

DoCmd.OpenReport "MyReport",,,"[ReportThisClient]=True"

Carl Rapson
 
Back
Top