Solution to tricky problem requires automation - A Suburbs Boy Living a Country Life — LiveJournal
[My Flickr Photos]
Solution to tricky problem requires automation|
|Date:||December 24th, 2007 05:48 pm (UTC)|| |
|Date:||December 24th, 2007 05:57 pm (UTC)|| |
I actually can't do the query with this, because I really need some sort of sequence or unique ID for the update query side of things. "First, last" is not a valid primary key [is not unique, and is null for some business entries without a name field].
However, this example might give you ideas.
The only likely unique id I can find is an OLE Object "EntryID." Apparently, though, you can't include OLE Objects in UNION queries.