Omar Lujan
asked on
InStr works, but InStrRev returns a data mismatch
Hi,
I'm trying to make a query in MS access. I'm having problems using InStrRev() - getting a data type mismatch error. Data Type is long text. InStr works, but InStrRev doesn't
This works
Expr1: InStr([Field],",")
This doesn't
Expr1: InStrRev([Field],",")
delimiter is a comma. I know it isn't ideal
I'm trying to make a query in MS access. I'm having problems using InStrRev() - getting a data type mismatch error. Data Type is long text. InStr works, but InStrRev doesn't
This works
Expr1: InStr([Field],",")
This doesn't
Expr1: InStrRev([Field],",")
delimiter is a comma. I know it isn't ideal
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
NZ() was exactly what it needed
Thanks!!
InStrRev(NZ([Field],''),",")