update query

S

Steve D

hi,

i have my main table containing many records. i was asked to add another
table that will hold names of employees. it must be a one-to-many
relationship to the main table. i would like to run an update query to add
the default value to all the previous records in the main table but am not
having any success. it tells me that i am about to update 0 records.

will update queries only work if the field you want to update already has
something in it?
 
D

Duane Hookom

This is a query news group. When you ask why a query doesn't work like you
think it should, it is appropriate to paste the SQL view into your email so
that we can help.
 
Top