Author Topic: Reprompt on a Joined Query  (Read 197 times)

Offline A.C.Sanchez

  • Associate
  • **
  • Posts: 2
  • Forum Citizenship: +0/-0
Reprompt on a Joined Query
« on: 12 Apr 2011 09:57:45 am »
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!