Queries

[Guest]

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

 

[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

Use a criterion on LastName of

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

John W. Vinson[MVP]