I am trying to use a filter like the following, but getting an syntax
error:
DoCmd.OpenReport "rptIndividualFeebackDetailByTeam", acPreview, ,
"RepresentativeTeam] = 'Client Information Center' And
(((Left([PolicyNumber],1)) In ('G','H','L')))"
I want only policy numbers beginning with G, H or L.
Thanks