I have a table that has names and worker ID's in them. I need the query to pull just the last 4 items in the name (the worker ID). how do i get a query to look at the last four letters in the whole field?
Novice
Windows XP 
Access 2010 32bit
Have a Query only look at the last 4 letters in a name
I have a table that has names and worker ID's in them. I need the query to pull just the last 4 items in the name (the worker ID). how do i get a query to look at the last four letters in the whole field?
Who is John Galt?
Windows XP Access 2007
This will return the last 4 letters:
Right(FieldName, 4)
Novice
Windows XP Access 2010 32bit
Thank you it works. never did no 2007
Who is John Galt?
Windows XP Access 2007
Count uppercase letters
Posting Permissions
Reply With Quote