Log in

No account? Create an account
Solution to tricky problem requires automation - A Suburbs Boy Living a Country Life — LiveJournal [My Flickr Photos]
December 24th, 2007
12:41 pm


Previous Entry Share Flag Next Entry
Solution to tricky problem requires automation

(6 comments | Leave a comment)

[User Picture]
Date:December 26th, 2007 02:18 pm (UTC)
So, looking at your query, it seems you're using it to create a list of contacts to keep, thus marking the rest for deletion. So you're creating two lists of unique IDs and want to remove the ones in the full list that are not on the keep list. There's two ways to do this.

The best way is to simplify matters by reprogramming your interface and just mark the ones you want to delete: Then it's DELETE FROM table WHERE id IN (1,2,3);.

The less optimal way (because you have to pull the list twice) is to say DELETE FROM table WHERE id IN (select statement to get the full list) AND id NOT IN (your list of selected IDs);

[User Picture]
Date:December 26th, 2007 05:00 pm (UTC)

problem is...

that in fact I'm not getting a unique ID, just an ID which I could later use to determine from which field that particular number.

So far as I can tell, the unique ID is a field called EntryID...which can't be included in a union query.

I could build up a recordset manually in VBA rather than using a union query...that might be the way to go.
Powered by LiveJournal.com