Using "In"

[BerkshireGuy]

I am trying to use a filter like the following, but getting an syntax
error:

DoCmd.OpenRepor t "rptIndividualF eebackDetailByT eam", acPreview, ,
"Representative Team] = 'Client Information Center' And
(((Left([PolicyNumber],1)) In ('G','H','L'))) "

I want only policy numbers beginning with G, H or L.


Thanks

[BerkshireGuy]

Re: Using "In&quo t;

Sorry everyone.

I was missing the [ before RepresentativeT eam.

Everyone who hates Syntax say "I".

"I" lol

Thanks