Using Left in a query to compare data in 2 Tables

[itsmythg]

=Left([Employee]![FirstName],4)=Left([Earthlink]![FirstName],4)
I am trying to pull information from 2 tables to create a new combined data Table. this returns no data and that I know is wrong.

 

[zoroaster]

Try putting:
Expr1: Left([Employee]![FirstName],4)=Left([Earthlink]![FirstName],4)
as an expression and a criteria of "True"

Laters, Z

"42??? We're going to get lynched!

 

[LaurelLee]

Try using the trim as well as the left. Sometimes my dbs add leading spaces for some reason, and that usually solves my problem when nothing is returned.
Trim(Left(([Employee]![FirstName],4))=Trim(Left(([Employee]![FirstName],4))

___________________________________________________________
With your thoughts you create the world--Shakyamuni Buddha