I believe the rule is

1. If the target table does not exist, or you wish to replace it use
SELECT ( fieldlist ) INTO [target] FROM [source] WHERE [source].field='some value';

2. If the target exists and you are appending rows
INSERT INTO [target] SELECT (fieldlist ) FROM [source] WHERE [source].field='some value';

with #2 you have some responsibility with duplicate rows. Stan