Search Two dates Range (1 Viewer)

[aftab1965]

I have a query " request" having a field "date". I inserted 2 text boxes on a form and a command button to search record of a date range from query and print a report of search results.
Any one plz help my in this regard

 

[bob fitz]

Use the Between operator and reference the two text boxes on the form in the criteria row of the date column in your query.

BTY: Date is a reserevd word and should not be used as a field name.

 

[aftab1965]

Thanks bob fitz
I am quite new in access, can you please help me by posting some coding for me?

 

[bob fitz]

What is the name of the form and the name of the two text boxes.
What is the name of the date field in the query.

 

[aftab1965]

Name of the Form is " Result"
Text box 1 is " DateFrom" and Text box 2 is "DateTo"
Query Name is "QryDateRange" and Filed is "DateEnrol"
Report Name is "RptDateRange"

 

[jdraw]

See this sample and try it info re Between from w3schools

I'm not sure what you have tried, but there are several free youtube videos regarding MsAccess Forms, SQL, etc.