If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
creating a table without multiple entries
There is some information regarding a disease for which the number of cases and case rates are stored for each year and for all the counties in a state. When designing a table for storing this information in Access, my table has repeated values for the county names for each corresponding year for saving the cases and case rates information. My table looks as follows: (below are my column headings) ID YearField CountyName Cases CaseRates ------------------------------------------------------------ 1 1988 county1 90 12.5 2 1988 county2 65 9.2 after storing the data in the above format, the year values and county names are being repeated. How can this kind of data be stored in access table(s) without any redundancy or multiple values of same field. thanks for any help. |
#2
|
|||
|
|||
You could create a table of County and Year combinations:
tblCountyYears ================= cyrCyrID Autonumber Primary Key cyrYear year value cyrCounty County value Then you can replace the YearField and CountyName with the cyrCYrID value. -- Duane Hookom MS Access MVP "talktobatchu" wrote in message ... There is some information regarding a disease for which the number of cases and case rates are stored for each year and for all the counties in a state. When designing a table for storing this information in Access, my table has repeated values for the county names for each corresponding year for saving the cases and case rates information. My table looks as follows: (below are my column headings) ID YearField CountyName Cases CaseRates ------------------------------------------------------------ 1 1988 county1 90 12.5 2 1988 county2 65 9.2 after storing the data in the above format, the year values and county names are being repeated. How can this kind of data be stored in access table(s) without any redundancy or multiple values of same field. thanks for any help. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating pivot table with multiple ranges in excel | Phil Policelli | Worksheet Functions | 2 | September 19th, 2004 05:07 PM |
STORE multiple values from a lookup table to another table. | beller | Database Design | 0 | June 15th, 2004 04:42 AM |
Probs with creating multiple pivot charts from pivot table | Retreatgal | Charts and Charting | 2 | January 28th, 2004 02:51 AM |