Re: Simple Select Query

Is this a one-time cleanup effort, or part of a larger strategy of putting
records in one table, then moving/copying them into another table? If the
latter, that's a very spreadsheetly way of approaching this. (hint: that's
not considered a compliment in these newsgroups...<g>)

Regards

Jeff Boyce
Microsoft Office/Access MVP

"THINKINGWAY" <THINKINGWAY@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0DFEA625-23DE-4BD5-952C-2226969B9F18@xxxxxxxxxxxxxxxx
I am trying to perform a select query to select all records that are NOT in
both tables. So I have tblPROJHIST and tblWMSNEW and they both have
project
# fields. What I am trying to do is find all the new project # records
in
tblWMSNEW that are not in tblPROJHIST and put them in tblPROJHIST.


Thanks


.

Loading