Type Mismatch

[DonnyF]

Hello,

I am trying to filter out one particular customer in a query and get the error type mismatch.

In my criteria row for 'CompanyName' I put:

<>"Astro Racing"

What am I doing wrong?

Thank you for the help,
Donny

 

[Joe4]

Do you have any erroneous entries in this field in any of the records?

 

[DonnyF]

I don't think so. When I search with this query without the criteria it lists all companies fine. The problem comes up when I try to filter out the one company.

 

[Joe4]

Try sorting by that field, and take a look at the first and last records for any oddities.
Is the field of Text data type?
Can you post the full SQL code for the query (switch the query to SQL View and copy and paste the code here)?

 

[DonnyF]

some of the customer names have dashes does that matter?

 

[DonnyF]

For instance:

Arizona Air-Craftsman

 

[DonnyF]

SQL view:

SELECT Workorder.ReceivedDate, Workorder.PartNumber, Workorder.SerialNumber, Workorder.AFRNumber, Workorder.CompanyName
FROM Workorder
WHERE (((Workorder.CompanyName)<>"The Gadget-Place") AND ((Workorder.CloseWorkOrder)=False))
ORDER BY Workorder.CompanyName;

 

[Joe4]

I see you have two criteria expressions in there.
If you remove the CompanyName one and leave the CloseWorkOrder one, does it work?

Also, the CompanyName field is not a lookup field, is it?

 

[DonnyF]

If I leave the closed one alone it works. The companyname is not a lookup up field.

 

[james_lankford]

try

select distinct 
  Workorder.CompanyName, 
  Workorder.CloseWorkOrder 
from 
  Workorder 
order by 
  Workorder.CompanyName

just to see if anything looks off