S
SharonInGa
The Excel spreadsheet will look like the example below. What's the best way
to set up the relationships in Access? How should I set up the spreadsheet
to import it into Access. Why is this project confusing me when I've used
Access on many projects with ease?
Should I create four tables and use three relationshiops? (one) ProductName
to (many) Product Types. (one)Product Type to (many) Quater Ends. (one)
Quarter End to (many) Values?
Product Name Product Type 1/31/2004 2/31/2004 6/30/2004
Prod1 Household .99 .89
.93
Prod1 Yard .24 .22
.22
Prod1 Auto 1.01 1.3
1.21
Prod2 Household .98 .89
.89
Prod2 Yard .24 .23
.23
Prod2 Auto 1.03 1.33
1.2
to set up the relationships in Access? How should I set up the spreadsheet
to import it into Access. Why is this project confusing me when I've used
Access on many projects with ease?
Should I create four tables and use three relationshiops? (one) ProductName
to (many) Product Types. (one)Product Type to (many) Quater Ends. (one)
Quarter End to (many) Values?
Product Name Product Type 1/31/2004 2/31/2004 6/30/2004
Prod1 Household .99 .89
.93
Prod1 Yard .24 .22
.22
Prod1 Auto 1.01 1.3
1.21
Prod2 Household .98 .89
.89
Prod2 Yard .24 .23
.23
Prod2 Auto 1.03 1.33
1.2