Re: Delete records based upon query results on another table

From: Sal Rosario (nodirectmail_at_cedrostec.com)
Date: 04/22/04 

Date: Wed, 21 Apr 2004 23:16:01 -0400

An example to answer your question can be found at www.salrosario.com.
Follow the link to downloads at the bottom of the page. Take care! 

--
Regards,
Sal Rosario
Microsoft Access Database Cosultant
www.salrosario.com
"Ryan Barnes" <ryan@rcbarnes.com> wrote in message
news:a75843b9.0404211554.19b3fc@posting.google.com...
> This may sound difficult at first, but I am sure it's not that
> complex.
> My situation is this, I have 2 tables. On one table I have a list of
> websites my users go to, on the other table I have a list of websites
> that I know are not pornographic, gambling, bandwidth waste, and so
> on. Sites like google.com and yahoo.com are good sites, so I want to
> delete them from my table of user's visits.. an example may help..
>
> GoodTable
> google.com
> yahoo.com
> msn.com
>
> WebHits
> www.hotmail.com
> www.espn.com
> www.google.com
> www.google.com
> www.yahoo.com
> www.networksolutions.com
> and so on..
>
> I want to have a query that will delete any records in the WebHits
> table that are LIKE any records in the GoodTable. For example..
> it would delete www.google.com because it was LIKE "google.com" see
> what I'm getting at?
>
> If you could help me out that would be great!

Relevant Pages

  • Re: Yet Another Web Application Mess...
    ... >care less about the customer's efficiency. ... address keyed in some unique form, yet not a one has ever phoned me or ... You must manually notify hundreds of websites, ... Ditto install programs that ask a question every 3 minutes for several ...
    (comp.lang.java.programmer)
  • Re: Talk UK forums
    ... We get people spamming their websites every week, ... showed what seems to be valid info. ... IMHO, there aren't enough committed Christians, but that's care ...
    (uk.rec.cycling)
  • Re: Funny AOL Story
    ... how's that fancy new Mac of yours running? ... websites I posted do anything for you? ... Take care. ...
    (alt.vacation.las-vegas)
  • Delete records based upon query results on another table
    ... This may sound difficult at first, but I am sure it's not that ... websites my users go to, on the other table I have a list of websites ... I want to have a query that will delete any records in the WebHits ...
    (microsoft.public.access.queries)
  • Re: Travel Agencies on this Newsgroup
    ... So you go to those websites. ... but Ray has been doing it for years and doing it fairly ... And I don't care what his motivation is because I can't read his ... I just know he is the one posting the latest cruise news. ...
    (rec.travel.cruises)