Access 2000 "Between" query question

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!

Jaycee66@jumpy.it

re: Access 2000 "Between" query question

Jaycee66 wrote:
[color=blue]
> 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.
>[/color]

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

[color=blue]
> 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])
>[/color]

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.