Simple problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
How do I copy a whole record from table1 to table2 if table1's field1
contains text "test"?
Click to expand...

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.
Click to expand...

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

Hope that helps


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