I have a report in which i am doing a union
query 3=query1 and query2
Query one has Region1 and territory1 from a query subject-1 and query 2 has region2 and territory2 from query subject2(alias shortcut of query subject1)
now the query three need two value prompts region and territory.
How do i make the prompts if the use value region and territory is taken from union query it gives me an error.
please can somebody advice
thanks
You can make a separate Union Query for prompt "Use Value" and "Display Value" only with Region and Territory