I am currently working on a web-e query in which the user can have many different limits, the problem is that they may not want to use all at the same time. Is it possible to have limits in a query that can be ignored by the user? for example:
Query1 has a prompt on Date, Operating Unit and Account Number,
The user Enters 10/7/2003 in the date prompt
then the user also enters 1000 in the Account Number Prompt and then leaves the Operating Unit prompt blank.
Can the user then run the query and get results? I tried this and it did not work, however I was hoping someone may have some idea of how to do this.
Julie Hussar (BOB member since 2003-10-08)
(BOB member since 2002-06-25)