update query

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

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query Issue 0
update query 2
Update query issue 0
Help! Need to update linked SQL table in Acc07 3
query is not updatable;; urgent 1
A Team Required for an update query 1
Create update query for remaining records 10
not in criteria fails 2

Back
Top