Apply filter

[Ferida]

How do I apply filters in macro

 

[Ken Snell \(MVP\)]

By using the ApplyFilter action. But as that's an obvious answer, I am
assuming that you're having a problem with the Where Condition argument?
Give us details, please.

 

[Ferida]

Thank you, I want to open a report that can be filtered with several date
range, says year by year or month by month.

 

[Ken Snell \(MVP\)]

Show us the names of the fields that you want to filter (the field names in
the table/query that is the report's RecordSource property), and some
examples of the dates that you'd use for filtering.

Also, for reports, one does not use the ApplyFilter action in a macro.
Instead, one uses the Where Condition argument in the OpenReport action.

 

[Ferida]

Thanks, the field name is entry date, and I want the report (name "Income
Statement") to show the record only for January 2008 and March 2008

 

[Ken Snell \(MVP\)]

Expression for the Where Condition argument would be this:

Format([entry date], "mmyyyy") = "012008" OR Format([entry date], "mmyyyy")
= "032008"

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/