[AccessD] Joining Two Tables

Is the problem the actual join syntax or the fact that there will never be a
match in the two fields? I'm guessing it's the latter, and if that's the
case, you could use a query expression to return just the variable-length
string (minus the suffix), and then join on that field. 

Sorry if I'm not understanding the problem. 

Susan H. 

Group,

I have two tables I would like to join.  Tbl1.Fld1 contains a
variable-length string, Tbl2.Fld2 contains the same variable-length string
concatenated with a variable-length suffix.

Any suggestions on how to proceed?  Is there an elegant solution?


Mark
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com