Date Range Report Based on two Seperate Date Fields

[iteach2]

If any can help me with this i really appreciate it.

Problem: I have a table that looks like this:


Number Starttime Endtime Startdate EndDate Descripton Type



Is there any I can create a report that will pull a Date Range based on the "Startdate" Field and the "EndDate field".

I have tried the " Between [enter start date] And [Enter End Date] expression. This expression will work if I enter a date that is physically written in the table, but if I enter a date range like...from 9/22/01(which is an actual date in the able) to 10/23/01(a date not actually written in the table) "but" falls between 10/28/01(a date actually written in the table)...the report comes back blank.

On the other hand if i input 09/22/01 to 09/24/00 (both dates actually written in table)...i get some results.

I thought about creating a new field called Date and setting the Control Source on a form for both "StartDate" and "EndDate" to it. But that would illeviate my "StartDate" "EndDate" Fields all-together and I need those fields to use in all other reports...they are very critical...Is there any way I can solve this problem.......

Please Help!!!!!! s-)

 

[nickjar2]

In the query have u tried:

Start date End date

>= [enter start] <= [end date]

Nick

 

[iteach2]

Thank a Bunch nickjar2...that worked perfectly...i owe you one buddy!!!!!!!!s-)