RE: How do I filter for more than 2 "does contain" criteria

The data area has a column heading:

data:

D11: Keywords
D12: word1
D13: word2
D14: word3

filter criteria:

D4: Keywords
D5: *word2*

It is not working with word2, *word2* and ="=word2".

I did everything like explained in the excel help, but it is still not
working.

Do you have any additional idea?

Thanks,

Alex

"Ron Coderre" wrote:

Does your list of words in the data area have a column heading?

Example:
D11: Keywords
D12: word1
D13: word2
D14: word3

etc

Criteria range:
D4: Keywords
D5: *word2* (or just word2, if you want an exact match)

"Keywords" over the criteria range tells Advanced Filter to look in the
column with that heading in the data range.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Alex" wrote:

Hi Ron,

thanks a lot for you inputs, but this does not work in my case.

I have a column called keywords.

I added :

D12: word1
D13: word2
D14: word3

The search criteria is the following:

D4: keywords
D5: *word2*

If I start the advanced search as you explained I see only word1. Word2 and
word3 are removed. However only word2 should be visible.

I don't know what is going wrong.

Thanks,

Alex

"Alex" wrote:

I want to filter a table with at least 5 "does contain" criteria.

However this is not possible with the "Auto Filter" and I couldn't figure
out how the "advanced filtering" worked.

Can anybody give me some ideas?

Thanks,

Alex
.

Relevant Pages

  • Re: Filtering Queries for Forms
    ... Just put the criteria into the Criteria row. ... what you do is to build a filter string based on whatever ... specific category and contain any of the keywords they enter. ... is any relational information or examples with InfoPath and Access Forms, ...
    (microsoft.public.access.forms)
  • Re: Autofilter
    ... from "Filter a Range" in the Excel help (written about ... autofilters), in the Notes section: ... > The criteria will not be judged independently. ...
    (microsoft.public.excel.programming)
  • Re: Filtering Queries for Forms
    ... Just put the criteria into the Criteria row. ... In essence, what you do is to build a filter string based on whatever criteria the user chose in your combo and/or text box, and then apply it as the Filter for your form. ... specific category and contain any of the keywords they enter. ... I have used InfoPath in the past which has the queries inherently built in, ...
    (microsoft.public.access.forms)
  • Re: Using check boxes to select items in a multi select list box
    ... This will be a single user situation, and if there are multiple users, they ... won't be trying to do data entry and filter records at the same time. ... Selecting and saving keywords works perfectly. ...
    (microsoft.public.access.forms)
  • Re: What is wrong w/ this query?
    ... I just thought I'd add that Access's right click-->apply filter function ... > This is to applied to each phase of the process: Turnaround between order ... > (TotalTurn, obviously, has to be at LEAST all the other criteria added up, ... can DateProd or DateProc be NULL? ...
    (microsoft.public.access.queries)