Creating/joining tables

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I want to create a table with the following info:

customer number
product
jan
feb
mar
apr
etc.

There are duplicate customers and duplicate products, but
there is only one customer number/product combination. I
have a download each month with 3 fields: customer
number, product, Jan. How do I join the next month's
download (customer number, product, Feb) into the same
table? I tried to create two separate tables (one for
Jan and one for Feb) and join them, but I only get data
where there's the same product in both tables. Any ideas
would be appreciated!
 
A better table design would be
customerNumber
product
monthNumber
valueField

For the Jan load, set monthNumber = 1, for Feb, set it to 2 etc

Hope This Helps
Gerald Stanley MCSD
 
If you are you using a VB procedure to load the data, then
run a query to select the Max(monthNumber) from the table
prior to beginning the load. Then monthNumber will be
incremented from this.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top