Unanswered: How to do a dlookup on a colmun that the critera might contain a % as the first char
I am looking to do a dlookup that will look up the distingused name of the Role Goup on a table. The issue is that the Group name might be like %PWFMSDB and as we all know the % is a SQL wildcard. I have tried a replace fuction as illistrated below but it is not working(Probably incorrect syntax). Any Ideas?