Creating/joining tables

[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!

 

[Gerald Stanley]

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

 

[Guest]

Gerald - I appreciate your help. Can you explain how to
set monthNumber? Thank you!

 

[Gerald Stanley]

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