Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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]
 
Back
Top