Simple problems

[Guest]

How do I copy a whole record from table1 to table2 if table1's field1
contains text "test"?

What is a simpliest way to just write "0" to table1's field1, field2 and
field3.

I'm not so familiar coding with Visual Basic in Access and don't have so
much time with project.

Thanks!

 

[Tim Ferguson]

How do I copy a whole record from table1 to table2 if table1's field1
contains text "test"?

The reasons for copying a whole record from one table to another are
incredibly rare. The answer to the question is generally, "just don't!"

What is a simpliest way to just write "0" to table1's field1, field2
and field3.

UPDATE MyTable
SET Field1 = 0, Field2 = 0, Field3 = 0
WHERE ReadyToBeZeroed = TRUE

Hope that helps


Tim F

 

[Guest]

Yes, thanks very much. Little modifications and works fine. I have to figure
something else for the copy-operation