Update query syntax

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

I am dumb as a rock today, somebody help! I want to update the contents of
table "Tracking Table II", field "Site Visit" to table "Master History",
field "Site Visit".
Please Help!! Thanks!!!
 
Backup your database first.

UPDATE [Tracking Table II], [Master History] SET [Master History].[Site
Visit] = [Tracking Table II].[Site Visit];
 
I am dumb as a rock today, somebody help! I want to update the contents of
table "Tracking Table II", field "Site Visit" to table "Master History",
field "Site Visit".
Please Help!! Thanks!!!
Click to expand...

More information needed. Let's say Tracking Table II has 31222 records and
Master History has 83102 records. WHICH record updates WHICH?

And... why are you trying to store information redundantly in two different
tables - or if you're not storing information redundantly, what ARE you
storing?
 
dont do Karls sloution it wont work because he is not joining the two
tables and will create a cartesian product that is of course if the
query will run regardless

to irritrate on johns post what connects the two tables how do you
define record x to be updated by record y in the other table.

Regards
Kelvan
 
Back
Top