Queries

N

na

Hi

The query that I am having difficulties with.

Query. Employees whose first name and last names begin with the same letter
(e.g.

Jill Jones).

Thanks

Myrna
 
J

John Vinson

Hi

The query that I am having difficulties with.

Query. Employees whose first name and last names begin with the same letter
(e.g.

Jill Jones).

Thanks

Myrna
Click to expand...

Use a criterion on LastName of

LIKE Left([FirstName], 1) & "*"

John W. Vinson[MVP]
 
Top