I am in need of some help. I tried looking for coding that will evaluate a query and show the First and Last Numbers based on the data in a sequential order but was not able to find anything.
For example I have created a query with car models and parts that fit those models listed as:
Manufacturer,Model,Year,Part Number,
Honda,Civic,2000,P-1,
Honda,Civic,2001,P-1,
Honda,Civic,2002,P-1,
Honda,Civic,2003,P-2,
Honda,Civic,2004,P-2,
Ford,Ranger,2000,P-4,
Ford,Ranger,2001,P-4,
Ford,Ranger,2002,P-5,
Ford,Ranger,2003,P-4,
And need it to show like:
Manufacturer,Model,Part Number,Beginning Year,End Year
Honda,Civic,P-1,2000,2002
Honda,Civic,P-2,2003,2004
Ford,Ranger,P-4,2000,2001
Ford,Ranger,P-5,2002,2002
Ford,Ranger,P-4,2003,2003
Thanks in advance!!!
For example I have created a query with car models and parts that fit those models listed as:
Manufacturer,Model,Year,Part Number,
Honda,Civic,2000,P-1,
Honda,Civic,2001,P-1,
Honda,Civic,2002,P-1,
Honda,Civic,2003,P-2,
Honda,Civic,2004,P-2,
Ford,Ranger,2000,P-4,
Ford,Ranger,2001,P-4,
Ford,Ranger,2002,P-5,
Ford,Ranger,2003,P-4,
And need it to show like:
Manufacturer,Model,Part Number,Beginning Year,End Year
Honda,Civic,P-1,2000,2002
Honda,Civic,P-2,2003,2004
Ford,Ranger,P-4,2000,2001
Ford,Ranger,P-5,2002,2002
Ford,Ranger,P-4,2003,2003
Thanks in advance!!!