Need To Automate Task

S

Santi

How can I automate the following task???

I have master file that I have in Access called “Monthly Price Changes and
Additions†which is dependent on information that is being sent to me via
email in excel format (which I’m importing to Access to a temporary table).
The file I get contains existing products with price changes or discounts and
additions of new products with prices and discounts. Each price change that I
get may contain several records with the same item number but with different
prices on each line depending on the discount given. What I need is for my
master file to be able to update the existing products and add a new records
of the same product number if a new discount is given and in addition I need
my master file to be able to take new products that are not yet listed.
Basically I want my master file to completely sync with the price changes and
discount and to leave existing records that do not have any type of changes.
Below is the current query I’m using but unfortunately it is adding new
products without the new item number and it is duplicating prices for the
same item which is not what I need.

DATE Master
RIGHT JOIN NYS
ON Master.[Item#] =NYS.[ Item]
SET Master.[DESCRIPTION] = NYS.[Description],
Master.[UNIT PRICE] = NYS.[PRICE],
Master.[COMMENTS] = NYS.[Disc $]
 
G

Gina Whipp

Santi,

This question has been asked three times now and you have received two
replies on, what I believe is, your second post. PLEASE we are volunteers.
We work when we have free time. Be patient and you will receive a reply or
two or ten but just keep posting because no one answered you right away.
Yours in not the only question to be anwered and by posting so many times,
we volunteers, *waste* time reanswering an already answered question.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top