tblHours has 2 less records than Machine Hours table.
I would like to say if [Machine Hours].[MODSER#] has a record not in tblNotes.[MODSERIAL#] then add it. I don't want any dulicates. Keeps saying there are zero records to add when there should be 2.
Expand|Select|Wrap|Line Numbers
- INSERT INTO tblNotes ( [MODSERIAL#] )
- SELECT [Machine Hours].[MODSER#]
- FROM tblNotes RIGHT JOIN [Machine Hours] ON tblNotes.[MODSERIAL#] = [Machine Hours].[MODSER#]
- WHERE ((([Machine Hours].[MODSER#])<>[tblNotes].[MODSERIAL#]));