I am trying to generate a report that requires the user to enter a date range once, and that date will then be used to generate several sub-reports based on queries. For example I have 7 tables that have a field named: [DateIn]. I want to use a query to calculate how many records have been created within the date range entered for each table and then summarize this on a report. I only want the user to enter the date range once. Thank you :-)