If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query Criteria With Prompt
Hi Folks - I have a query criteria row that looks like this: Not In
(Status1, Status2). Basically, I do no want to see those status' in the query result. However, now I need to provide a prompt to the user for additional status'. For instance, Status1 and Status2 will continue to be excluded, but I need to "filter" the query further with another status such as: Not In (Status1, Status2) And "Status3". In addtion to this, I need this: Not In (Status1, Status2) And Not "Status3". Lastly, I'll need a way to display all records, BUT still excluding Status1 and Status2. I'd like to do this with a parameter prompt, if possible. Any ideas? Thanks. Michael |
Thread Tools | |
Display Modes | |
|
|