By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,335 Members | 2,218 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,335 IT Pros & Developers. It's quick & easy.

Need help querying previous quarter information

P: 1
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)
Expand|Select|Wrap|Line Numbers
  1. MonthNo: DatePart("m",[Current Date])
.

Then is another field that querys a table I have tried several criteria statement, this being the most recent
Expand|Select|Wrap|Line Numbers
  1. 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.
Feb 14 '07 #1
Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,366
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])
Feb 14 '07 #2

NeoPa
Expert Mod 15k+
P: 31,494
Don't be smart Rabbit ;)
I'm sure they would have if they'd known about it.
Feb 15 '07 #3

Rabbit
Expert Mod 10K+
P: 12,366
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.
Feb 16 '07 #4

NeoPa
Expert Mod 15k+
P: 31,494
I was just pulling your chain Rabbit :D
It was a good point anyway.
Feb 16 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.