Using User Response to Select Specific Data

[Ed Prieto]

In one Query I request Inventory records for a specific point in time (eg. wk 5) based on a user prompt/user response.

In the second Query I request future demand based on a submission date, one week later than former query. (eg. wk 6) In the data set I have demand for the next 6 weeks, 6,7,8,9,10........

I created a user response varible (char) and performed tonumber fromula to create number. I need to bring the two queries together to calculate estimated days of inventory. The problem is that I get # computation errors. If I define the varible where wk is = 6 for eg. the data works. I want the report to be dynamic based on either user response.

Help.

[dcdas]

In your first query use the to_char(date,'WW')=@prompt(..)
and in your second query use to_char(submission_date,'WW') > @PROMPT(use same prompt as first..)


(FOR oracle)