Matching one field to a 2nd

[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.____

[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