Report for users

[dawnlowery]

I need a report which will list all users that have lastnames that are 5 characters or less. Anyone have something ?

[dawnlowery]

THANK YOU both for your help! I really appreciate it.

[Hemoco · Accepted solution]

Select tblADusers.Username, tblADusers.Userdomain, tblADusers.Firstname,
  tblADusers.Lastname, Len(tblADusers.Lastname)
From tblADusers
Where Len(tblADusers.Lastname) <= 5