Return Loan Data Associated with a Range

[Bean Machine]

Hi Everyone!

I am in the process of trying to create a query that will pull from user input and return all of the different loans associated with a range of dates that the user inputs. I have a field called "Loan Date" in a query which is effectively just the day the loan was put into the system. I have two text boxes on a form, one called txt_StartDate and the other called txt_EndDate with the purpose of these text boxes being to limit the data being taken in or to find what items are un-returned or have been loaned in a specified period. I have tried this code: Between [Forms]![Item Search]![txt_StartDate] And [Forms]![Item Search]![txt_EndDate]

I have also tried this as well: >= [Forms]![Item Search]![txt_StartDate] And <= [Forms]![Item Search]![txt_EndDate]

These lines of code are under the Loan Date Field on the query if that helps clear things up. Thanks for any help!

 

[arnelgp]

remember to type the two dates on the format of your system date, so that the query will return meaningful data.