Query Criteria
Query, SQL
Hello. I have a report with multiple subreports. User enters date range when prompted from query in main report. I want to refer the subreport date criteria to the date range the user enters for the main report, via the query. I used this in the query criteria under the date field[reports]![mainreport].[fieldname], but the criteria is a Between....and.....dates and the subreport only picks up the first day of the month entered. How do I refer to that criteria in the subreport criteria so the user only has to enter the date range a single time?Thank you
0
