Skip to Content
Former Member
Dec 12, 2006 at 04:43 PM

Workbook - Query problem


Scenario -

Workbook attached with 2 queries as below.

Query 1 –

Fiscal year – variable (user input)

Posting period – variable (user input)

Query -2

Fiscal year/Period – Replacement path Variable from Query -1

Replacement path variable should fill the values of Fiscal year and Posting period from Query-1 to Query -2 Fiscal year/period , so user dont have to key in input .

Workbook - Query - <b>Properties</b> (Refresh query when opening Workbook) has been set for all 3 queries.

currently while opening workbook it directly goes to query-2 and fails instead of going to query 1.

How to achieve it??

thanks for help