I have two queries (query1 and query2), one of which contains [Product Type]. The queries are joined (Main Query), and produce correct output. I want to add an optional reprompt to my report, based upon [Product Type].
I have another query called p_Product Type, which is the parameter for my prompt. When I then point my query to this parameter, should I do that in the original query1, or in the joined Main Query? Or does it need to be in both?
I can't figure this out for the life of me!