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

Access 2000 "Between" query question

P: n/a
Access 2000 "Between" query question:
I am relatively new to MS Access and everytime I think I have a basic
concept of the program it pokes me in the eye with something I think
would be simple to create.

I want to create 2 separate queries for a label. I would like to have
the query prompt me for the date I choose to start from until the
present date and the other to prompt me for the date I choose to start
from and 2 additional numbers of days.

I tried this express for the second of my queries for the Criteria but
it didn't work. Why?

Between [Table]![Field] And DateAdd("d",2,[Table]![Field])

I have absolutely no clue how to create the other query. If anyone out
here can help I would greatly appreciated it and so would what left of
my hairline!

Ja******@jumpy.it
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Jaycee66 wrote:
Access 2000 "Between" query question:
I am relatively new to MS Access and everytime I think I have a
basic concept of the program it pokes me in the eye with something
I think would be simple to create.

I want to create 2 separate queries for a label. I would like to
have the query prompt me for the date I choose to start from until
the present date and the other to prompt me for the date I choose
to start from and 2 additional numbers of days.

1) As criteria for the DateField:
Between [Enter Start Date] and Date()

I tried this express for the second of my queries for the Criteria
but it didn't work. Why?

Between [Table]![Field] And DateAdd("d",2,[Table]![Field])


As criteria for the DateField:
2) Between [Enter Date] And DateAdd("d",2,[Enter Date])

You will be prompted to enter the start date.
The first example will return all records from that date to the
present.

The second example will return all records for the start date and 2
additional days.

--
Fred
Please reply only to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.