Forum Discussion
MS Access: Looking to find a way to check for matches across two fields based on character position.
Apologies for the long involved title. I'm super rusty and don't remember all the exact correct jargon. I have a database with 30 or so fields. One of those fields is just a simple Fiscal Year fie...
There is function RIGHT() to separate last two digit from string. Post few sample data and desired output. Attach a sample database (.accdb) file.