Hi, i am completely new to filtering queries and wondered if anyone could help.
I have a query that shows a 'product list' with their relevant serial numbers, what i am trying to do, is simply block two products from being displayed.
I use product ID in my query yet display the product name. In the query i went to the criteria line of the product ID (in design view) and put the code
<>"88" And <>"89"
This returned the error 'type mismatch in expression' . i tries the same procedure using the full name of the product and the same error message was returned.
Can anyone help?? Thanks in advance
S
I have a query that shows a 'product list' with their relevant serial numbers, what i am trying to do, is simply block two products from being displayed.
I use product ID in my query yet display the product name. In the query i went to the criteria line of the product ID (in design view) and put the code
<>"88" And <>"89"
This returned the error 'type mismatch in expression' . i tries the same procedure using the full name of the product and the same error message was returned.
Can anyone help?? Thanks in advance
S
