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

 

[DonnyF]

Thanks for the video. I created a new query with the Workorder table and the Customer table showing the join between ID from Customer table and CompanyName from the Workorder table. I included all of the same fields and put the same criteria as in the initial query from this post.

Same results I get the error type mismatch.

 

[Joe4]

Please post the SQL code for your new query, and list out the fields in your Customer Table.

 

[DonnyF]

SELECT Workorder.ReceivedDate, Workorder.AFRNumber, Workorder.PartNumber, Workorder.SerialNumber, Workorder.CompanyName
FROM Customer INNER JOIN Workorder ON Customer.ID = Workorder.CompanyName
WHERE (((Workorder.CompanyName)<>"American") AND ((Workorder.CloseWorkOrder)=False));


Customer Table:

ID
CompanyName
FirstName
LastName
Address1
Address2
City
State/Province
Country
Phone1
Phone2
Fax
Email
Website
Notes

***
ID is primary key and autonumber. All else are short text fields

 

[DonnyF]

Maybe the State/Province is the issue?

 

[stumac]

You are still checking the numerical field in the Workorder table for your text string, you should put the criteria against the field in the customer table....

SELECT Workorder.ReceivedDate, Workorder.AFRNumber, Workorder.PartNumber, Workorder.SerialNumber, Workorder.CompanyName
FROM Customer INNER JOIN Workorder ON Customer.ID = Workorder.CompanyName
WHERE (((customer.CompanyName)<>"American") AND ((Workorder.CloseWorkOrder)=False));

 

[DonnyF]

Thank you very much that was it!

I am so sorry for all the trouble.

 

[DonnyF]

It works great but I have a question. Is the field 'State/Province' okay the way it is with the slash?

 

[stumac]

No problem

Yeah, access will allow the slash and I don't think it causes issues in the application (since 2010 anyway) . I personally don't use any non alphanumeric characters, but this is due to issues I found with other databases years ago now.

 

[DonnyF]

Okay I am using Access 2013 and I will leave it be. I appreciate all the help.