dates

G

Guest

I have used criteria as shown belown only problem with this formula is when
you get to oct 2006 my query shows

200610 200604 200605 200606

i need the October month to be at the end can anyone help please.

thankyoooooooo
Kate

Month Year:
IIf(DatePart("yyyy",DateAdd("m",-3,[ApptDate]))=2006,DatePart("yyyy",[ApptDate]) & Month([ApptDate]))
 
G

Guest

Change to this --
Month Year:
IIf(DatePart("yyyy",DateAdd("m",-3,[ApptDate]))=2006,Format([ApptDate],
"yyyymm"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running month sum 2
Filtering by Month 1
Crosstab with multiple Column Header Fields 6
URGENT HELP NEEDED WITH GETTING AVERAGES BY QUARTER 1
query will not work between years 7
Invalid use of null 3
Type mismatch in Function 5
Sort on Date 1

Top