Linking Fields

[Scott]

I have two text fields in different tables that I want to link. Both are
employee number fields. However, the field from my payroll file is six
characters long and has preceeding spaces before the number, i.e. " nnn"
the other table is from my accounting software and it does not have
preceeding spaces, i.e. "nnn". Is it possible to link two text fields
together?

Thank you,

Scott

 

[geomike]

Scott,
Yes it is possible to link two text fields together. However, the contents
must be the same for the database to recoginize them. For instance, using
first and last names, Thomas Franks is not the same as Tom Franks. I would
consider using one field that is common to both tables, say EmployeeID and
then tie both payroll and accounting to EmployeeID. I have at least 6 pairs
of people who share the same name, so you have to be careful how you link
your data.

Mike

 

[Scott]

Is it possible to link the two fields directly without modification even
though the one field has 3 spaces preceeding the employeeID?

Thanks, Scott

 

[geomike]

The fields must be identical for the link to occur.

 

[S Panja]

Try using Trim function.