Append query question - simple

[Miethr]

Just fooling around, I need to make a shell of my Database because I will be ending my internship soon and I can't control the information in my database for legal reasons, but I still want to have the database shell to show my skills of using access (recently required and not extensive ) so here is the problem


making an append query to clear out 10 fields, not delete just enter either no value or null, just a blank record, but this is for 175 records. I can get it to work for the first record but nothing else. here is my SQL

INSERT INTO WeldingSpecification ( Substitute1, Substitute2, Substitute3, Substitute4, Substitute5, Substitute6, Substitute7, Substitute8, Substitute9, Substitute10 )
SELECT " ", " ", " ", " ", " ", " ", " ", " ", " ", " ";


I am sure this is completely wrong, but I am just kinda fooling around with it. Any guidance is appreciated.

Riley

 

[67flyer]

I would use an update query not an append.

UPDATE WeldingSpecification SET Substitute1 = Null, Subsitute1 = Null;

just keep adding the fields you need

 

[Miethr]

works great

67


helpful to use the correct tool for the job! Worked swiftly and effectively.

Thanks

Riley

Don't use a hammer to kill a fly