Update a Quantity

  • Thread starter Thread starter R. BRADFORD THOMAS
  • Start date Start date
R

R. BRADFORD THOMAS

Good Evening,
I am using Windows 2000 and Access 2000.

I have a Table1 with a field Quantity1 and a Table2 with a field Quantity2.
I want to update Table1 by adding the field Quantity2 to Quantity1.

Can I use a Query to do this update? How?

Brad
 
Good Evening,
I am using Windows 2000 and Access 2000.

I have a Table1 with a field Quantity1 and a Table2 with a field Quantity2.
I want to update Table1 by adding the field Quantity2 to Quantity1.

Can I use a Query to do this update? How?
Click to expand...

Yes. However you need some other field in each table to link the two
tables together, so Access can tell which record in TableA should get
which quantity in TableB.

Join the two tables on this field (and if it doesn't exist, you'll
need to create it); and update Table1.Quantity1 to

[Table2].[Quantity2]

The brackets are required (or it will try and fail to update the
quantity to the text string "Table2.Quantity2").
 
Thank you John for your quick response,

I think I misled you. I do join the tables with an ItemNumber. Your
suggestion helps.

Brad


John Vinson said:
Good Evening,
I am using Windows 2000 and Access 2000.

I have a Table1 with a field Quantity1 and a Table2 with a field Quantity2.
I want to update Table1 by adding the field Quantity2 to Quantity1.

Can I use a Query to do this update? How?
Click to expand...

Yes. However you need some other field in each table to link the two
tables together, so Access can tell which record in TableA should get
which quantity in TableB.

Join the two tables on this field (and if it doesn't exist, you'll
need to create it); and update Table1.Quantity1 to

[Table2].[Quantity2]

The brackets are required (or it will try and fail to update the
quantity to the text string "Table2.Quantity2").
Click to expand...
 
Back
Top