Help with filter

[BerkshireGuy]

I have the following filter in a report:

[MonYer] = 'August 2005' and [RepresentativeTeam] = 'Client Information
Center' And Left(PolicyNumber,1) = 'Z' or 'H'

My intention is to have records returned if in August 2005 with the
Client Information Center as the team and any Z or H policies.

However, the above filter is returning ALL (every month and team) H
policies.

Do I need to rewrite to read:

[MonYer] = 'August 2005' and [RepresentativeTeam] = 'Client Information
Center' And Left(PolicyNumber,1) = 'Z' OR [MonYer] = 'August 2005' and
[RepresentativeTeam] = 'Client Information Center' And
Left(PolicyNumber,1) = 'H'?

I hope not - seems wordy! :)

[Salad]

BerkshireGuy wrote:

I have the following filter in a report:

[MonYer] = 'August 2005' and [RepresentativeTeam] = 'Client Information
Center' And Left(PolicyNumber,1) = 'Z' or 'H'

My intention is to have records returned if in August 2005 with the
Client Information Center as the team and any Z or H policies.

However, the above filter is returning ALL (every month and team) H
policies.

Do I need to rewrite to read:

[MonYer] = 'August 2005' and [RepresentativeTeam] = 'Client Information
Center' And Left(PolicyNumber,1) = 'Z' OR [MonYer] = 'August 2005' and
[RepresentativeTeam] = 'Client Information Center' And
Left(PolicyNumber,1) = 'H'?

I hope not - seems wordy! :)
Use () to make a true/false condition. Frankly, I don't see how your
filter even works. What is an Or H?

"[MonYer] = 'August 2005' and " & _
"[RepresentativeTeam] = 'Client Information Center' And " & _
"(Left(PolicyNumber,1) = 'Z' or Left(PolicyNumber,1) = 'H')"

[pietlinden]

[MonYer] = 'August 2005'
AND [RepresentativeTeam] = 'Client Information
Center'
AND Left(PolicyNumber,1) In ('Z' ,'H');

...maybe...