G Guest Jun 9, 2005 #1 I have a basic Select Query with a parameter of [Enter Policy Group]. Is there a way to make that parameter a wildcard search? Thanks.
I have a basic Select Query with a parameter of [Enter Policy Group]. Is there a way to make that parameter a wildcard search? Thanks.
G Guest Jun 9, 2005 #2 Like "*" & [Enter Policy Group] &"*" This gives you wildcard on both left and right. Omit left "*"& to make wildcard only on right.
Like "*" & [Enter Policy Group] &"*" This gives you wildcard on both left and right. Omit left "*"& to make wildcard only on right.