Access question

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

Guest

How do I exclude records with a particular value in a field when running a
report.
For example: I have a field ("Relationship") that has three possible values:
("Other", "Core", "Advisory").
I have designed a report that sorts initially based on the Relationship
field.
I want the report to run, but not display any records with value "Other" in
the Relationship field.
How do I do this?
 
Exclude "other" in the underlying query upon which your report is based.
Not "OTHER"

If you are running the report straight from a table, use the report filter.

Use the help file if you need help with the format, or post back with a
specific question.

Rick B
 
hand said:
How do I exclude records with a particular value in a field when running a
report.
For example: I have a field ("Relationship") that has three possible values:
("Other", "Core", "Advisory").
I have designed a report that sorts initially based on the Relationship
field.
I want the report to run, but not display any records with value "Other" in
the Relationship field.
Click to expand...


You can use a query with that as a criteria as the report's
record source.

Alternatively, I usually prefer to use the OpenReport
method's WhereCondition argument to filter the report
(assuming you use a form button to open the report).
 
Thanks, I ended up going back and creating a new report based on a query
which filtered out 'other', before I had just run a straight report.
Thank you.
 
Back
Top