Can I do a Criteria to filter by text?

[net]

Hello,

Is it possible to do a criteria like the "Between" to pull data like a work order number?

Ex WO#: WO5551212

I would like to be prompted to enter a Work Order Number when I run a query, then have the query display all of the data for that particular work order number.

Thank you.

 

[plog]

Yes. Bring in the work order field into your query and in the criteria section put this:

[Enter Work Order]

Run and it will prompt you for data.

 

[net]

Great! That is what I was looking for.

Is it possible to enter multiple work order numbers or no?

 

[plog]

Yes, but it would be annoying.

You would keep going down in that criteria area adding input boxes:

[Enter Work Order 2:]
[Enter Work Order 3:]
[Enter Work Order 4:]
[Enter Work Order 5:]

And everytime you run it you would have to work through 5 prompts, even if you only wanted 1 work order.

 

[net]

Aww, got it.

Okay, thanks so much for your help. It is working great!