Merging Data

[Michael Sainz]

Hey all,
Don't know if this is the correct thread so if not, please post a reply
to where this might question could be answered.
I have a database set up with a table named Cost and a table named All.
Both tables have a column named SKU. [Cost] has around 16000 entries while
[All] has around 6000 entries. Cost has the SKU and my cost that my
distributer sends me. [All] has product description ect for all the product
that I want to sell. Difference, I am only selling some of the stuff. That
is why [Cost] is bigger then [All]. I would like to cross-merge the [Cost]
data to the [All] data based on the column SKU. This database is Access
2003, but I will be moving it to MSSQL soon once its ready. Will I need a
custom module created for this because I can do that. Also, this isnt a one
time deal. I have inventory that is email to me at 12:00am every night that
will be like this also. That is why i'm asking about the custom module.
Any help is much appriciated.

Michael Sainz
(e-mail address removed)

 

[Joseph Meehan]

Hey all,
Don't know if this is the correct thread so if not, please post a
reply to where this might question could be answered.
I have a database set up with a table named Cost and a table
named All. Both tables have a column named SKU. [Cost] has around
16000 entries while [All] has around 6000 entries. Cost has the SKU
and my cost that my distributer sends me. [All] has product
description ect for all the product that I want to sell. Difference,
I am only selling some of the stuff. That is why [Cost] is bigger
then [All]. I would like to cross-merge the [Cost] data to the [All]
data based on the column SKU.

I don't think that is what you really want to do. If I understand what
you have and want, and I am guessing about part of it, you should look at a
query to display the results you want keeping the data like it is.

Issues:

Do you have more than one entry is the "All" table for any one SKU?
How about the other table?
Do you want a history or just a current result?

Note: Always design tables at the start and use queries to get combined
data.

 

[Guest]

Hello

Sounds to me as if an update query is in order here. Add two fields to your All table, a Description field and a Date field. Run an update query on the All table, updating the Description field with the description from the Cost table. Add a criteria on your date field so that you limit your updates to the newest ones.

Bob Sullivan
----- Michael Sainz wrote: ----

Hey all
Don't know if this is the correct thread so if not, please post a repl
to where this might question could be answered
I have a database set up with a table named Cost and a table named All
Both tables have a column named SKU. [Cost] has around 16000 entries whil
[All] has around 6000 entries. Cost has the SKU and my cost that m
distributer sends me. [All] has product description ect for all the produc
that I want to sell. Difference, I am only selling some of the stuff. Tha
is why [Cost] is bigger then [All]. I would like to cross-merge the [Cost
data to the [All] data based on the column SKU. This database is Acces
2003, but I will be moving it to MSSQL soon once its ready. Will I need
custom module created for this because I can do that. Also, this isnt a on
time deal. I have inventory that is email to me at 12:00am every night tha
will be like this also. That is why i'm asking about the custom module
Any help is much appriciated

Michael Sain
(e-mail address removed)