Compile Error

[P B via AccessMonster.com]

I am getting this error:

Compile error. in expression ".

while trying to save this query:

SELECT dupelist.*
FROM dupelist INNER JOIN dupelist AS Dupe
ON dupelist.DOB = Dupe.DOB AND Left(dupelist.LName,1) = Left(Dupe.LName)
WHERE dupelist.ID <> Dupe.ID;

in SQL view. Please help.

 

[Gijs Beukenoot]

From P B via AccessMonster.com :

I am getting this error:

Compile error. in expression ".

while trying to save this query:

SELECT dupelist.*
FROM dupelist INNER JOIN dupelist AS Dupe
ON dupelist.DOB = Dupe.DOB AND Left(dupelist.LName,1) = Left(Dupe.LName)
WHERE dupelist.ID <> Dupe.ID;

in SQL view. Please help.

Because Left(Dupe.LName) is missing the length parameter (,1)

 

[P B via AccessMonster.com]

SELECT dupelist.*
FROM dupelist INNER JOIN dupelist AS Dupe
ON dupelist.DOB = Dupe.DOB AND Left(dupelist.LName,1) = Left(Dupe.LName,1)
WHERE dupelist.ID <> Dupe.ID;

still produces Compile error in expression ". Puts the cursor on dupelist.
DOB. Seems like it should be so easy. I've tried it with and with out an
existing Dupe table. I'm not sure about that part (whether the INNER JOIN
creates the table or if it needs to exist).

From P B via AccessMonster.com :

I am getting this error:

[quoted text clipped - 8 lines]

in SQL view. Please help.

Because Left(Dupe.LName) is missing the length parameter (,1)