Search by LAST WEEK / LAST MONTH / LAST YEAR

[floyd]

I have a list box in a form with the following Row Source:

"Between Date() And Date()-6";"This Week";"Between Date() And Date()-30";"This Month";"Between Date() And Date()-90";"This Quarter"

which is supposed to run a query.



If I use "Between Date() And Date()-6" in the search in the query it works, but if I try to use it in the list box, I get an error that "The expression is typed incorrectly, or is too complex to be evaluated".

What am I doing wrong?

I also tried...

">=DateAdd("m";-3;Date())";"Past Quarter";">=DateAdd("m";-1;Date())";"Past Month";">=DateAdd("d";-7;Date())";"Past Week"

[June7]

This is doing something I've never seen. Try this in the query as the filter parameter (no idea if it will work):

Eval([Forms]![yourlistboxname])

I don't use parameterized queries. I use code to set Filter and FilterOn properties or to set the WHERE CONDITION argument of DoCmd.OpenForm (or Open Report).