WHERE (((table1.FIELD1)="HEADR"));" - I get an error

[scottian]

I have this :-

DoCmd.RunSQL "INSERT INTO HEADR ( FIELD1 ) SELECT table1.FIELD1, table1.* FROM table1 WHERE (((table1.FIELD1)="HEADR"));"

but access doesnt like it and highlights the HEADR in "HEADR"

any suggestions

"My God! It's full of stars...

 

[PHV]

You must have the same number of columns (ie one) in your select clause as in the insert into one.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244