I would like a all records from [Master Log] (a table) where [Master Log].[Disposition]="Rejected" and input those records into the [Rejected] (a table). Both tables are exactly the same as far as structure. I have created a macro with one RunSql Statement.
[Code]
INSERT INTO [Rejected] SELECT ALL FROM [Master Log] WHERE [Master Log].[Disposition]="Rejected"
[Code/]
It says there is a syntax error, do you have any ideas?
Also, could I run this from a form, or do I have to create a macro in order to do it.
Actually, I want to then delete the "rejected" records from the master log. Would I create another runsql statement? How might it look?
[Code]
INSERT INTO [Rejected] SELECT ALL FROM [Master Log] WHERE [Master Log].[Disposition]="Rejected"
[Code/]
It says there is a syntax error, do you have any ideas?
Also, could I run this from a form, or do I have to create a macro in order to do it.
Actually, I want to then delete the "rejected" records from the master log. Would I create another runsql statement? How might it look?
Comment