I am trying to make a one-page report that is made up of multiple sections. Each section uses a different query.
The queries I use have the same parameters names defined to get a start and end date.
I tried to make a report with sub reports, in an effort to get all the same info on one page, but I get prompted for the date parameter 4 times, even though the parameter names are the same throughout all queries.
I am not sure if I should be using unbound objects or maybe define the variables globally in VBA <--still learning.
Hopefully I explained my problem well enough. If not I'll reply asap with further clarification.