Filter using two criteria

[BrookieOU]

I have a form that has a combo box that I am using for my filters. That
combo boxed is based on a table that defines the filters. I am having
problem writing the Filter String so that it uses two criteria.

I would like the filter to be based on an employee table and reference the
"Active_Employee" field and the "Client" field. I want the "Active_Employee"
field to be "Yes" and the "Client" field to be "1". Here is how I currently
have it written: ([Employee Detail].[Active_Employee]=Yes) & ([Employee
Detail].[ClientID]=1). When I run the filter it does filter by the correct
ClientID, but it doesn't apply the "yes" criteria for the "Active_Employee"

Anyone know why?

Thanks,
Brooke

 

[Jerry Whittle]

I believe that you need the word AND instead of the ampersand &.

 

[BrookieOU]

Yeah, I was just coming back on to say I figured it out. Thank you!

I believe that you need the word AND instead of the ampersand &.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have a form that has a combo box that I am using for my filters. That
combo boxed is based on a table that defines the filters. I am having
problem writing the Filter String so that it uses two criteria.

I would like the filter to be based on an employee table and reference the
"Active_Employee" field and the "Client" field. I want the "Active_Employee"
field to be "Yes" and the "Client" field to be "1". Here is how I currently
have it written: ([Employee Detail].[Active_Employee]=Yes) & ([Employee
Detail].[ClientID]=1). When I run the filter it does filter by the correct
ClientID, but it doesn't apply the "yes" criteria for the "Active_Employee"

Anyone know why?

Thanks,
Brooke