not found query

[a.mlw.walker]

Hi.
I have two tables, both with load of info. I need to run a query, that checks data in table1 against data in table2. If it is in table two, then moves on. If it is NOT, then shows the results to me. So that i can see which ones were not there.
how do i go about that.

thanks
Alex

 

[Moniker]

In your query, link Table1 to Table2 on the key fields (assuming you have that at least) using a left join. In the query grid, drag all the fields from Table1 down, and drag only the field(s) from Table2 that are the key field(s). Set the criteria in the key field(s) in Table2 to Is Null. Run that query and it will only return the records from Table1 that are not found in Table2.

 

[a.mlw.walker]

Thanks, it didnt work though, just showed me the titles of the columns, but absolutely no data. (By key field you mean the ones I am interested in, and by left hand join, you mean drag the name of one field onto the other right?)

 

[KeithG]

You need a left join from table1 to table

 

[a.mlw.walker]

Right. This is my problem. I have a list of 120000 entries of the names of companies. and they have website addresses related to them. say, the AA and website theaa.com
I have another table with 108 websites in that i have to see if they are already in the entries, and if they are not, add them.
The only problem is that in the records the websites are as www.theaa.com, and the ones i have to add are as theaa.com How do i run a query, that will check whether part of the website matches, and if it doesnt, show me.

thanks
alex

 

[KeithG]

Make a query from the table and use the below as a column, it will add the www. to all the entries.

"www." & [FieldName]

[FieldName]=Name of you field


now make a join from this field to you field in the other table.

 

[a.mlw.walker]

Sorry, I'm quite new to access but boss, asking me to do some quite demanding stuff - but thanks for quick reply!
What you are telling me to do is:
1. Make query in design view
2. open table, i wish to add www. to
3. double click on the name of the field that i wish to add www. to
4. in the next field box, in the query table, type "www." & [FieldName]
5. join the two with an arrow.
how do i do the last two steps (assuming the rest is correct)

Thanks
Alex

 

[a.mlw.walker]

thanks, I somehow managed to do it