I'm trying to make a form where the final user can type in two dates (date range) and the result will generate a report on all activity between those two dates, any ideas ?
Quite simple, and it's been covered here many times. 2 basic ways are to have the report's source query use the 2 form controls in its criteria, or use them in the wherecondition argument of OpenReport.