Form to search for data by date range

[andyt_2005]

Hi guys,

I have an issue i think can be solved by giving the user a form to select a date range from (from date to date) and produce a report with the outcome.
However i have absolutely no idea how to even attempt this!


Any ideas or help from the masters out there?

[June7]

Options:

1. dynamic parameterized query as the report RecordSource:
SELECT * FROM tableORquery WHERE DateField BETWEEN Nz([Forms]![formname]![starttextbox], #1/1/1900#) AND Nz([Forms]![formname]![endtextbox], #12/31/2900#);

2. code to build filter criteria and pass to report in OpenReport argument - VBA example:
DoCmd.OpenReport "report name", , , strCriteria
Review http://www.allenbrowne.com/ser-62code.html

[NTC]

J7's advice is correct, but perhaps a little intimidating for the novice. Essentially what you do is put the text boxes in your form - let's call them StartDate and EndDate in MyForm (don't use the word Date - it is reserved)....

Then in the query that is the record source for the report (or if the report is sourced directly on a table you must first make a query) - here you add your 'call' as your query criteria from the form:
Forms!MyForm.StartDate is the syntax

If you are dealing with a single date column/field then probably: >=Forms!MyForm.StartDate AND <=Forms!MyForm.EndDate

[andyt_2005]

Guys Thank you ! managed to get it workign will both your help! Now onto my next issue .. . fun and games