Hi, I have one table with one field(Primary key-text field). I enter digits in this field. I want to show only the last 3 characters of each record (string) so this is the critaria I use in the query builder:
This is the SQL code that Access generates based on my query:
What is wrong with this. I have no results from this. 10x in advance.
The solution you gave me works just the way I want it to. Still I don't get why my query didnt. In the access help file it reads that "Right" returns the rightmost characters of a string:
Right("abcdefg",4) returns "defg".