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

Query set within a specific amount of days

P: n/a
I am a new user and am trying to create a query to show the renewals
that will come up within the next two months. I already have:
Now()And
I am not sure how to input "two months"

Please Help
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Michelle, You could use something like this as the criteria for under your
renewal date field. Cut and paste this in the criteria.

(Air Code)
Between Date() And DateAdd("m", 2, Date())

This will return renewals between todays date and 2 months from today.

--
Reggie

----------
"Michelle" <ms*******@peregrin.ca> wrote in message
news:26**************************@posting.google.c om...
I am a new user and am trying to create a query to show the renewals
that will come up within the next two months. I already have:
Now()And
I am not sure how to input "two months"

Please Help

Nov 13 '05 #2

P: n/a
Michelle
Have a look at a function DateAdd in MS Access help.
Galina
ms*******@peregrin.ca (Michelle) wrote in message news:<26**************************@posting.google. com>...
I am a new user and am trying to create a query to show the renewals
that will come up within the next two months. I already have:
Now()And
I am not sure how to input "two months"

Please Help

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.