parameter query and calculating date

[gregbecker2001]

Hi all,
I'm trying to build a parameter query that will return obs which meet criteria acccording to date. It's a little cumbersome to explain so here's my example::

name being_date end_date
project1 7/1/02 10/15/02
project2 5/1/02 8/1/02
project3 2/13/02 5/12/02

the user get prompted for a begin date and enters 7/1/02, and enddate 7/1/02. this should return project1 and project2 because both projects were running in that month.

Any help would be greatly appreciated.
-Greg

 

[Geoff Codd]

In your criteria enter

Between [Enter Start Date] And [Enter End Date]

Geoff

 

[gregbecker2001]

Thanks Geoff, but i don't understand how to use that in a criteria becasue it not referring to any field on the table.

In your criteria enter

Between [Enter Start Date] And [Enter End Date]

Geoff

 

[Hayley Baxter]

This may be of some use to you.

Hay

 

[antomack]

This might help you.

 

[Pat Hartman]

In the criteria field for begin_date
>= [Enter Begin Date]

In the criteria field for the end_date
<= [Enter End Date]