General discussion

Locked

Filter Information in a report in Access

By dee ·
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").

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Filter Information in a report in Access

by kkenkel513 In reply to Filter Information in a r ...

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.

Collapse -

Filter Information in a report in Access

by dee In reply to Filter Information in a r ...

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

Collapse -

Filter Information in a report in Access

by Dennis@l In reply to Filter Information in a r ...

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).

Collapse -

Filter Information in a report in Access

by dee In reply to Filter Information in a r ...

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

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums