Unclear of syntax of aggregate function. I realize I should write a VBA script but time is crucial.

Two tables, I would like to compare the company name from each table.
Because the names differ slightly in each table, I would like to trim the last characters or use only the first 8 characters.

I need help on the aggregate function:

tables: table1, tables2
column titles: company (identical in both tables)

Do I write the formula in a new column in each table so that I can then compare the results? The column would be "trimmed" in both tables.

Do I follow these steps?

Insert column names from all tables in query?
In the trimmed column, I should have "expression" instead "group by," correct?
Enter this formula in the criteria?

=dfirst(["table1"]!["company"],"trimmed") Prob incorrect.

What do I put on the left hand side of the formula? ["table"]!["trimmed"]

What about quotation marks?

Help!




=DFirst([Jan 19]![IO Company],[jan 19])