Need help querying previous quarter information

[Mike S]

I am trying to set up a query that automate pulling the previous quarters data.

I have an expression field that changes Date() in to a month only(1-12)

MonthNo: DatePart("m",[Current Date])

.

Then is another field that querys a table I have tried several criteria statement, this being the most recent

IIf([MonthNo] Between 1 And 3,"4th")

. I will then use some or statements to find the other three quarters.

Needless to say this is not working nor is about 25 other iterations. I have even put the first calculation in its own table, which works, but I had trouble link this table with the rest of the query.

Any help would be great. I am under the gun to get this competed ASAP since I will be taking a 1yr. military leave of abscence.

[Rabbit]

Would it not be more to the point if you just went straight to quarter instead of going through month?

Qtr: DatePart("q", [Current Date])

[NeoPa]

Don't be smart Rabbit ;)
I'm sure they would have if they'd known about it.

[Rabbit]

Don't be smart Rabbit ;)
I'm sure they would have if they'd known about it.

I wasn't NeoPa =P
It may be that he needs month information as well.

[NeoPa]

I was just pulling your chain Rabbit :D
It was a good point anyway.