Updating Fields with Different Values?
Hi,
Bring TableB and TableC in a new query, Join their common fields Items,
edit the join to keep all the records from TableB. Transform the select
query into an update query. Drag TableC.Quantity in the grid, in the
UpdateTo line, write: [TableB].[Quantity]. That's all. Not only existing
Items are updated, but if a new item is mentionned in TableB, it will be
append to TableC.
AS USUAL, make a backup if you are making tests on your real life data....
Hoping it may help,
Vanderghast, Access MVP
Quote:
> I have a linked table (A) from a .txt file to retrieve data from a bar
code
> scanner. Since this .txt file changes I have an append query to another
Table
> (B) to store it. I need all the changes in Table "B" Updated in Table (C)
> For Example If Table "B" has:
> Item Quantity
> beans 2
> soup 3
> soap 7
> And Table "C" already has:
> Item Quantity
> beans 1
> soup 0
> soap 4
> How do I get Table "C" to:
> Item Quantity
> beans 2
> soup 3
> soap 7
> I've written a module that cuts and pastes, looping through each record
until
> the end. But that seems to sloppy to me. There must be a better way.
> Thanks for any help you can offer,
> Al
