dates

K

kate

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]))
 
K

KARL DEWEY

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

Filtering by Month 1
Type mismatch in Function 5
Invalid use of null 3
How to query data on monthly basis 3
using dates Part 2 0
URGENT HELP NEEDED WITH GETTING AVERAGES BY QUARTER 1
Field is being truncated after simple query is run, even though nogrouping is taking place 1
Cross tab - complex IIF 2

Top