Ask Your Question
1

how can I create more than 3 filters on a query?

asked 2016-05-31 01:18:39 +0100

goedible gravatar image

I only see three options for filtering queries and forms. I'd like to create more. How can I apply more than 3 filters? Thanks.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2016-05-31 01:59:55 +0100

Ratslinger gravatar image

updated 2016-05-31 02:55:42 +0100

When using the dialog there are only three items as you stated. After completion the filter box may look something like this ( "Test2"."ID" = 32 ) OR ( "Test2"."ID" = 33 ) OR ( "Test2"."ID" = 36 ). You can always add directly onto this string whatever conditions such as ( "Test2"."ID" = 32 ) OR ( "Test2"."ID" = 33 ) OR ( "Test2"."ID" = 36 ) OR ( "Test3"."ID" = 26)

Additional Info: Sorry, you did ask about queries also. The above refers to forms. With queries you are probably referring to the Wizard. At the last step of the wizard, select Modify the Query. There you can add more filtering under Criterion.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-05-31 01:18:39 +0100

Seen: 78 times

Last updated: May 31 '16