ksklos at comcast.net
ksklos at comcast.net
Sun Dec 17 17:48:28 CST 2006
That what I was thinking, Susan. But how do I isolate the records with three letters at the beginning from the records with 7 numbers or 1 character at the beginning and 6 numbers? -------------- Original message -------------- From: "Susan Harkins" <ssharkins at setel.com> > I'd create a new field for both by parsing just the six characters you need, > then join on that field. > > Susan H. > > Here is the rub. Most of the entries in the courses fields match because > they are 7 numbers or they both have the character+6 numbers combination. > There are approximately 1800 records that need to be matched with the 3/3 > combination. How do I isolate just those records that need to be matched > using the 3/3 combination? Here is an example: tblCourses: SPN1101, > SPN2101, SPNL101, can match with tblMajors: SPNX101. I hope this is > understandable. I can send more examples if needed. Thanks. > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > Internal Virus Database is out-of-date. > Checked by AVG Free Edition. > Version: 7.1.409 / Virus Database: 268.15.9/573 - Release Date: 12/5/2006 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com