2 Table Query matching similar fields

[newestAF]

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.

 

[SkipVought]

Hi,

What database application?

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

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[newestAF]

Access 07. Yeah, I overlooked that.

 

[SkipVought]

There are MANY MS Access forums to choose from.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]