They Kind of match

[kholm]

I need to compare two tables. That is not the problem the problem is in Table A only the first 6 letters for the same information is listed. So, Table A has AGGREV, which I need to match with Aggrivated Assult in Table B.

 

[Jack Cowley]

Create a query based on Table A and add a Column similar to this:

FindBy: IIF([YourFieldName] = "AGGREV", "Aggrevated Assault", "")

Now compare the query with the TableB.

hth,
Jack

 

[neileg]

Create a query based on Table B and add a calculated field like this
FirstSix:Left(yourfield,6)
Then match the field in Table A with the new field in the query