I have a main report that is produced according to an embedded query. The person must enter in a Fiscal year and the dates are pulled from a fiscal year table and used to compare date fields in another query in the main report.
The subform uses the same first query that gets the dates.
When I run the report, it asks for the Fiscal year 4 times. How can I make it so that it only asks for the Fiscal year once.
Thanks in advance, Mary Beth
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.