Page 1 of 1
Matching one field to a 2nd
Posted: Thu Feb 05, 2004 1:01 pm
by cepes
I am trying to match the first 7 digits (out of 9) of one field in Database A with the 7 digit code in Database B. I may be doing this backwards but when I try to join the two tables, I cannot because the fileds don^t match, and my attempts to set a low match end in a syntax error.____
=> RE: Matching one field to a 2nd
Posted: Thu Feb 05, 2004 4:36 pm
by kfleming
If they are both character fields then you would create a relation that uses a partial match of 7 characters. If they are numeric, then you would need to create a calculated field to turn them into characters and then grab the first 7 characters only.____Kathleen__R&R Support