cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dawnlowery
Engaged Sweeper
I need a report which will list all users that have lastnames that are 5 characters or less. Anyone have something ?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Select tblADusers.Username, tblADusers.Userdomain, tblADusers.Firstname,
tblADusers.Lastname, Len(tblADusers.Lastname)
From tblADusers
Where Len(tblADusers.Lastname) <= 5

View solution in original post

2 REPLIES 2
dawnlowery
Engaged Sweeper
THANK YOU both for your help! I really appreciate it.
Hemoco
Lansweeper Alumni
Select tblADusers.Username, tblADusers.Userdomain, tblADusers.Firstname,
tblADusers.Lastname, Len(tblADusers.Lastname)
From tblADusers
Where Len(tblADusers.Lastname) <= 5