Query certain fields

[Yecats131]

Hello!

So, I would like to create a query that asks for a parameter, and runs that parameter against specific types. Let me give you an example:

Status: I have a total of four status types that a Requisition can have. For this particular query, I want it to be ran for only 2: Pending and Approved

Parameter: I want the user to be able to select etiehr Addition or Replacement.

Expression that I'm using but doesn't seem to work:

Status: "Pending" or "Approved"
Requisition Type (Paremeter): [Enter ADDITION or REPLACEMENT]

I've tried using "Pending" AND "Approved" but that is looking for one's that match, right?

I might not even be on the right track.. but I apprecaite any help I can get.

Thanks!

 

[Dennisk]

if you want to use more than one value in your criteria there are two ways to do this.

1) use the boolean operator OR i.e. = "A" OR "B"

2) use the IN operator i.e. IN("A","B")

 

[Yecats131]

Oh! "IN" was what I needed. Thanks a ton :0)

 

[Yecats131]

Okay, so for some reason it isn't working still. I have 73 Req's that have the status of "Approved" - Most of which are addition. When I run my query based off of the parameter of "Addition" it pops up with only 10 requestions. This just isn't right.... and I'm not sure what is happening.

Here is the experessions that I am using:

Status: In ("Pending","Approved")
Req Type: [Enter ADDITION or REPLACEMENT]

Edit: I just realized that it is pulling 10 req's which have the status of "Approved" or "Pending" so it is viewing both... just not pulling all of them...

Thanks!

 

[Dennisk]

if the status fields at the table level are lookups with a datatype of long integer then you need to use the numeric values and not the text.