Converting a Query from SQL Sever to Access 1

[DrSeussFreak]

 SELECT Right([Last Name], CharIndex(' ', Reverse([Last Name]) + ' ') - 1) [Last Name], from contacts

This is code written for SQL Sever, but I am not sure of how to make it work in Access. Any ideas?

 

[AlexCuse]

CharIndex(' ', Reverse([Last Name]) + ' ')

should be replaced with

InStrRev([Last Name], ' ')

You also should look at the regular InStr function, if you are going to be converting a lot of queries from SQL Server, as this is the replacement for the standard Charindex.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom