I've done some searching for this answer and only found similar ones but nothing that would seem to really help me. I have 2 tables [TblReport] & [TblAccounts].  The accounts table includes a field called agency and the report table has a similar field called case status. Case status has the agency inside the data but also includes "referred to" or "action completed", etc at the beginning.  I can't change that. That's the way I receive it. I need to link the fields together to ID who to send the reports to. The accounts table has e-mails associated to the agency field. I'm assuming some time of Trim but not familiar with using it. Agency names vary in length and with the spacing. I have absolutely no idea where to start. Could really use some help.

Hi,

What database application?  

BTW, this is a GENERAL data access forum, not MS Access data access.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

Access 07. Yeah, I overlooked that.

There are MANY MS Access forums to choose from.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}