Pulling a specific date into a query

[ajenson]

I am trying to build a query pulling information from multiple tabs/tables in my data base. One of the tables is a list of dates. When I run the query I want it to only pull the most recent date (or allow me to chose the a date range). Is this possible and if so, how?

 

[Ranman256]

Make a form, put 2 text boxes for the date range, txtStartDate,txtEndDate.
The query will use the text boxes as criteria.

Select * from table where [date] between forms!frmMain!txtStartDate and between forms!frmMain!txtEndDate