Quick question, I have a table in Access 97 that I have to do a search on, and return only the records that end in a certain character. I messed with the Right function, but couldn’t get it to return the values that I want. Can anyone either give me an example of how I should approach this, or maybe another function that I’m not aware of that I could try? Thanks
In your Query Criteria, enter Like “*a”.
This will find all the records that have entries in that field that end in “a” (in my example).
Note that this will find “South Africa” but not “Kuala Lumpur”.
Gp