T
terryv
I would like to use a select query, I don't know sql or vba well enough, but
can normally produce a pretty good access query.
From table 1 I want to use 4 fields, date, ID, code and URL (as text). Table
two has a field with a large list of base URLs, ie. "proxy.net".
Normally I would just use criteria Like "*proxy.net*"; however, with 3000
proxy sites to compare to this list of hundreds of thousands of URLs I need
to know the syntax to compare the list in table two to the list in table one.
What is the syntax for the criteria? If there's any more information I can
provide I'm happy to do it.
Thanks
can normally produce a pretty good access query.
From table 1 I want to use 4 fields, date, ID, code and URL (as text). Table
two has a field with a large list of base URLs, ie. "proxy.net".
Normally I would just use criteria Like "*proxy.net*"; however, with 3000
proxy sites to compare to this list of hundreds of thousands of URLs I need
to know the syntax to compare the list in table two to the list in table one.
What is the syntax for the criteria? If there's any more information I can
provide I'm happy to do it.
Thanks