Create duplicate records for entries with year ranges

[rebubula]

Hi. I am trying to figure out a way to create duplicate records for entries with year ranges. Here is an example of what I am working with:

Input:
Years Make Model Part Number
1997-1999 Dodge Ram 1500 123456

Desired output:
Years Make Model Part Number
1997 Dodge Ram 1500 123456
1998 Dodge Ram 1500 123456
1999 Dodge Ram 1500 123456

Any help is greatly appreciated. Thanks!

 

[Montez659]

More than likely, what you will want to do is not have duplicate records like that. I am just going off the sample you provided, but if the only thing that is going to change is the Year, then what you will want is different tables, one with all the info for the parts with PK, Part, Number, where PK is your primary key set to autonumber. Another table for Vehicle, with PK, Year, Make, Model, again PK set to autonumber. A third table would be a Joined table, would contain it's own PK, and the two FK (foreign key's). The FK's are the PK's from your other two tables.

Doing it like this would ensure that you are not duplicating the same info over and over and is good practice.

Here is some more reading: http://office.microsoft.com/en-us/access-help/join-tables-and-queries-HA010096320.aspx

And more: http://www.allenbrowne.com/casu-06.html