Append Queries

  • Thread starter Thread starter magmike
  • Start date Start date
M

magmike

I need to add the data of the RegID field in one table to the empty RegID
field of another where the email address of the second is equal to an email
address in the first.

I tried my hand at this yesterday, and ended growing my records to about
899,000 from a mere 5,000.

Can anybody help me with this?

Thanks,
Mike
 
i suspect you tried to use an Append query. this situation calls for an
Update query. try this:
write a Select query to pull the record(s) you want to update. once that is
running correctly, open the query in design view and click Query, Update
from the menu bar; this turns the Select query into an Update query but
without changing the criteria, etc. search for "update query" in Access Help
for information on how update queries work.

hth
 
Back
Top