Date + 1 month

[quabba]

Hi everyone. I've got a database that I need to extract some info from. I need to extract up to the current date + 1 month. I've tried various things but they only give me the current years results and not any in the past years ie 2012, 2011. can someone help.

[pbaldy]

Try a criteria of

<= DateAdd("m", 1, Date())

[quabba]

Try a criteria of

<= DateAdd("m", 1, Date())

Hi pbaldy, I've tried that with no luck, I've got this for the month <=Month(Date())+1 and this for the year <=Year(Date())

[pbaldy]

Is your field a date/time field or are you storing month and year (I would have a date/time field)? Can you post the db here?

[quabba]

Is your field a date/time field or are you storing month and year (I would have a date/time field)? Can you post the db here?

Hi pbaldy, that has worked. I just checked my query and I had another conflicting field set for the date. Don't know how I never seen it before. Thanks for your help..

[pbaldy]

No problem, and welcome to the site!