Variable Fields

[Joe]

I am trying to run a search where it would take the
Between function and find all the fields within that
range. How do I get Access to prompt for those two dates
so that each time I want to run the query I can just enter
the two dates instead of changing the "formula" for the
criteria?

 

[JohnFol]

Depends on where the search is being run from. If it's a report, have alook
at the "Sales By Year" report in the sample Northwind db. If it's just
opening a query, just add it into the SQL. For example

SELECT MyDateField, MyOtherField FROM Table1 WHERE MyDateField Between
[Enter Start Date] And [Enter End Date];



Add them into the QBE grid