Filering records based on two date fields

[BrandonM30]

Good afternoon,

I am trying to build SQL code that will filter records on a table based on the information chosen on two form control date fields, and only after the second date is chosen.

Do you know how I would go about that?

I would like the table/query to be able to be required at any point in time, and give me information based only on the date choices.

Thank you in advance for your assistance.

 

[Ranman256]

The form will have 2 text fields,
TxtStartDate, txtEndDate.

Put a button on the form to open the query. Do not open on end date entry. The user can make an error.
Upon the btn click event, open the query,
Docmd.openQuery "qsDateRange"

The query references the form dates.....
Select * from table where FldDate between forms!frmMain!txtStartDate and forms!frmMain!txtEndDate

 

[BrandonM30]

Thank you very much! This helped out a ton!