M
Michael
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
(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