Multiple Criteria Filters from Same Field (1 Viewer)

S

shatteras

Registered User.

Local time

Today, 01:03

Joined

Apr 11, 2016

Messages

25

• Sep 6, 2016

• #1

hello, I would like to know how to filter (from form property sheet) on load, I have this on Data/Filter/Property Sheet; DocName = 'NEWops' ... but I want to display not just the 'NEWops'. I wanted to display NEWops, PREops, DCVops as well. they all belong to the DocName field... please help? thank you...

 

S

sneuberg

AWF VIP

Local time

Today, 01:03

Joined

Oct 17, 2014

Messages

3,506

• Sep 6, 2016

• #2

Have you tried?

DocName = 'NEWops' Or DocName = 'PREops' Or DocName = 'DCVops'

 

S

shatteras

Registered User.

Local time

Today, 01:03

Joined

Apr 11, 2016

Messages

25

• Sep 6, 2016

• #3

I tried that but with an AND.... lemme try the OR now.. thank you. I think I could use the IN but I don't know how...

 

S

shatteras

Registered User.

Local time

Today, 01:03

Joined

Apr 11, 2016

Messages

25

• Sep 6, 2016

• #4

it worked! thank you..... thanks a lot

 

S

sneuberg

AWF VIP

Local time

Today, 01:03

Joined

Oct 17, 2014

Messages

3,506

• Sep 6, 2016

• #5

shatteras said:

I think I could use the IN but I don't know how...

Click to expand...

I believe you could use IN too and be more consise

I believe that would be

Code:Copy to clipboard

DocName IN ('NEWops', 'PREops', 'DCVops')

Sorry, Didn't think of that.

 

S

shatteras

Registered User.

Local time

Today, 01:03

Joined

Apr 11, 2016

Messages

25

• Sep 6, 2016

• #6

thanks for showing how to use the IN method. thank you for the help guys. I can finally move from here, ciao ^_^