Access Query to filter out list based on multiple row criteria from another table

[zeeshanaslamdurrani]

I have googled and also searched this forum but I am not able to find a solution for this.

I have an access database in which I have a table A and table B. Table A has a list of 200 website URLs. Table B has one coloumn ID and another criteria.

I want to create a query to filter websites list which does not have values or characters from table b.
I have these values in table B that I want to be filtered out or not shown in my URL Select Query

.org
.gov
.du
.pk
.dk

I would keep on adding more criterias into this so criteria table so adding new criteria into table B should not disturb our filtering.

I thought this is easy but really I don't seem to find a solution to this. Any help is highly appreciated. Below is what I have tried but in vain and it says atmost you can atmost one criteria row in sub query

SELECT tableA.WEB_ADDRESS
FROM tableA
WHERE ((([tableA].[wEB_ADDRESS] Not Like '*'+(SELECT * FROM tableB)+'*')=True));

Best regards,
Zeeshan

 

[spikepl]

queries forum, first post

 

[zeeshanaslamdurrani]

Dear below is my query

SELECT tableA.WEB_ADDRESS
FROM tableA
WHERE ((([tableA].[wEB_ADDRESS] Not Like '*'+(SELECT filter FROM tableB)+'*')=True));

I am trying to filter table A with parameters from Table B

Getting an error
You can not more than one criteria in subquery.

If I enter only one criteria in table b then the above query works. But more than one values I get error mentioned above.

Dear I have tried this so far and hope you would give me a solution this time. My requirement is quite clear

 

[zeeshanaslamdurrani]

queries forum, first post

Dear I am here to seek help and help others. So I guess there is nothing bad in telling what I am not able to do. If you are expert in access you should have helped me. Thanks Zeeshan Durrani