Updating Master information...

  • Thread starter Thread starter MAXWELL
  • Start date Start date
M

MAXWELL

Help,

Trying to update a MASTER cross reference Table. It
contains informations (UPC code, Retail price & cost,
Description, etc...) for all Items beings sold (There are
no duplicates). Need to compare cross reference to a
weekly download of NEW sales coming in. They are both
TABLES. The new weekly sales download MAY have some new
items not captured in my MASTER cross reference. How do I
capture the new items using a quick and accurate query so
I can update the master cross reference Table?

Please help
 
It looks thet you have two issues to solve. Please
correct me if I am wrong.

1) update records in MASTER that match records in NEW
sales

2) add records from NEW table, that do not exist in MASTER

For issue 1) you need a simple query taht joins MASTER
and NEW, then make it update query and update fields in
MASTER from NEW

For issue 2) you need an unmatched query. Unmatched query
returns all records from NEW that are not in found
MASTER. Then you make it append query and that is it.
Access has a wizard for building unmatched queries. The
wizard works well when you have only one field used for
joining tables. For two or more fields, you have to build
the query yourself. If you need help with that, let me
know. We will ned to know a bit more details about your
tables.

:-)
 
I guess what i meant to say was the following. Given both
tables have a common denominator = UPC Number. What i
wanted was, if there is a UPC number in TBL2 that is not
in TBL1 then show me these UPC numbers, otherwise show me
nothing. How do i do this in a query format and then
append the new UPC numbers BACK into TBL1 so that it now
has all the UPC's that TBL2 had.

I hope this made more sense.

Please help. Thx
 
Back
Top