Web Development·12,096 discussions

Filter Information in a report in Access

Locked

How can I set criteria in a report so I can filter to text. For example I have a database that deals with variations for a document based on which state it is being used in. Some of the states use the generic document. How can I run a report to extract the states that use the generic form. ( In the “Variation” field of my database table, it says “Generic Form”).

Topic

Filter Information in a report in Access

In reply to Filter Information in a report in Access

Your report should be based on a query. The query should have all the fields that you want to display in the report and the Variation field (even if it’s not displayed on the report). In the Criteria line under the Variation field in the query, enter “Generic Form”. The Grid column for Variation looks like this:

Variation
tablename

checkbox
“Generic Form”

Create your report based on this query.

Filter Information in a report in Access

In reply to Filter Information in a report in Access

Are you saying to have a seperate column in the table to say either “generic ” or “varaition”? That could be do-able.

Filter Information in a report in Access

In reply to Filter Information in a report in Access

The filtering criteria is done in the query design view. In the field that has the states listed, select the criteria and type the state as listed in the field (GA/Georgia).

Filter Information in a report in Access

In reply to Filter Information in a report in Access

I need to know how to select the criteria for a report

[Author]

Replies