They Kind of match

kholm

Registered User.
Local time
Today, 07:03
Joined
Jun 25, 2001
Messages
63
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.
 
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
 
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
 

Users who are viewing this thread

Back
Top Bottom