Have a Query return results within a date range

[BZeyger]

I have a form that refers to a query that contains:

Project Name
Start Date
End Date

The form has 2 text boxes (Start Date and End Date) and a command button.
This is where the user would enter a date range. Once the command button is
clicked, the query (located in a subform) would return the results that fall
in the date range.

How would I do this? Would I put something in the query or would I have to
code something in the command button.?

 

[Jeff Boyce]

The command button "opens" the query.

The query needs to include a date/time field to compare to, and would use
something like the following for the selection criterion under that
date/time field:

Between Forms!YourFormName![Start Date] And Forms!YourFormName![End
Date]

If that doesn't (quite) work, you'll need to define these two as parameters,
of type Date/Time, inside the query design window.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

Would I put something in the query
Yep.

Use this as criteria on your date field --
Between [Forms]![YourFormName]![Start Date] And
[Forms]![YourFormName]![End Date]

 

[Jeff Boyce]

Having looked over other responses, I need to get some clarification...

Is it your form that has two controls ([Start Date] and [End Date]), or are
you saying that your underlying table has two date/time fields?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Having looked over other responses, I need to get some clarification...

Is it your form that has two controls ([Start Date] and [End Date]), or are
you saying that your underlying table has two date/time fields?

Or both... and you want to return records where there is any overlap between
the two ranges?

 

[BZeyger]

The form contains the text boxes for Start Date and End Date. The subform
appears in a datasheet view which shows a Name, start date and end date

Having looked over other responses, I need to get some clarification...

Is it your form that has two controls ([Start Date] and [End Date]), or are
you saying that your underlying table has two date/time fields?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a form that refers to a query that contains:

Project Name
Start Date
End Date

The form has 2 text boxes (Start Date and End Date) and a command button.
This is where the user would enter a date range. Once the command button
is
clicked, the query (located in a subform) would return the results that
fall
in the date range.

How would I do this? Would I put something in the query or would I have to
code something in the command button.?