vmurray
asked on
MS Access 2007 Multiple Filter onLoad
Simple request.
How can you add multiple filters to a MS Access 2007 report.
I have 2 fields:
1: Print (TRUE/FALSE)
2: Select Type (TypeA, TypeB)
I want to do a simple filter when loading a report that only displays the values WHERE
[Print] = "TRUE" and [Select Type] = "TypeA"
How can I simply do this?
How can you add multiple filters to a MS Access 2007 report.
I have 2 fields:
1: Print (TRUE/FALSE)
2: Select Type (TypeA, TypeB)
I want to do a simple filter when loading a report that only displays the values WHERE
[Print] = "TRUE" and [Select Type] = "TypeA"
How can I simply do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have used Select Type as "Type A" with a space. You have used it without a space. So you might have to make those changes
ASKER
Didn't really get it from the query statement code... but "use the recordsource of the report" did it for me.
I ended up going to the report properties, clicking on "Record Source, ..." and adding each field. I then added "Criteria" to the 2 fields...
ie: TRUE and "TypeA"
It automatically added the statement to the Record Source along with the selected table.
There are too many ways to do 1 task in Access... but this is from someone who doesn't use it much. Thanks.
I ended up going to the report properties, clicking on "Record Source, ..." and adding each field. I then added "Criteria" to the 2 fields...
ie: TRUE and "TypeA"
It automatically added the statement to the Record Source along with the selected table.
There are too many ways to do 1 task in Access... but this is from someone who doesn't use it much. Thanks.
ASKER
The key was "recordsource of the report"... Thanks.
That is true. You could also first create a query and then use it as a recordsource for your report. Or you can use the above select statement directly as the recordsource of the report. You could also invoke the query builder by clicking on the ellipse on the recordsource property and then design the same query from the query grid. So yes there are many ways to do one task. Good Luck!