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

Comparing input date to current date

P: n/a
Hi,
I'm working on a class project in which I have to create a simple hotel
reservation database using Access. I've created a couple of tables and
queries that allow a user to determine room availability on a queried
range of dates.
What I now want to add to that query is a statement that will not
accept an input date prior to the current date of greater than a year
from the current date. Can someone please help me with this?

Warning!!! I am an absolute Access amature, so please explain this in
the simplest terms possible.

Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

ToysNTreasu...@gmail.com wrote:
Hi,
I'm working on a class project in which I have to create a simple hotel reservation database using Access. I've created a couple of tables and queries that allow a user to determine room availability on a queried
range of dates.
What I now want to add to that query is a statement that will not
accept an input date prior to the current date of greater than a year
from the current date. Can someone please help me with this?

Warning!!! I am an absolute Access amature, so please explain this in
the simplest terms possible.

Thanks


put a validation rule for your field
Between Date() AND Dateadd("yyyy",1,Date())

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.