View Records between two dates...

[airteng2]

Hi, I am trying to figure out how to get my query to return the records I need based upon dates (2 dates) entered in a form.

For example:

The date field is "Entry Date"

I want to view all records entered between Jan 1 2002 and Jan 1 2003.

The Form is "frm Date Parameter"
Start Date is "Text0" the user will enter 01/01/2002
End Date is "Text2" the user will enter 01/01/2003

How do build the query to recognize that both dates are for the same table field (Entry Date) and return the correct records for viewing?

Going in 'greater than' and 'less than' circles...

 

[Mike Powell]

Dates

In the query that you have made, you will ( or should have ) the date field. In the criteria box simply type "Between [Enter First Date] And [Enter Last Date]" Don't put the " " in though. When the query runs, it will ask for A First date and Last date. Only records with dates between these will be output.


Mike

 

[airteng2]

GOT IT!!!!

Thanks for the input...

I feel so stupid sometimes...
Here is the solution...

if it doesn't look right let me know...

By selecting Entry Date twice while creating the select query I am able to use both of the forms criteria for the correct return result...

Start Date: Entry Date
<[Forms]![frm Date Parameter]![Text2]

End Date: Entry Date
>[Forms]![frm Date Parameter]![Text0]

 

[Mike Powell]

It looks ok to me. I have just tried it on a test db, and it works.

Mike

 

[airteng2]

Thanks Mike!

It is so difficult sometimes to put into words what you have planned for data, in such a manner that others are able to understand and assist...

I need all the help I can get in my efforts. So glad to have found this site!!

Good Day!