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]

I am not sure why this is not working but thanks for helping.

 

[Joe4]

I think this might be one of those errors that requires someone to have access to the database to see what is going on.

 

[stumac]

Are you sure it isn't a lookup field? It wouldn't make sense to save the company name as a text field in the workorder table.

Try running this query:

SELECT CompanyName & "" AS TestName FROM  Workorder

Are you given a list of company names as expected or a list of underlying numbers?

 

[DonnyF]

There is a Workorder form that has a combo box to select and add to the companyname list that populates the Customer table. The query is based on the Customer table the has the field CompanyName.

Do these details help?

 

[Joe4]

Yes. What is the Primary Key field in the Customer Table?
Usually, that is the value that is being selected (but not always the value being displayed).
My guess it is a numeric field, which is the reason for your error.

Try adding the Customer Table to your query, joining on the Primary Key field.
Then, add the display field to the query, and place your criteria under that.

 

[DonnyF]

The primary key is an autonumber in the Customer table. I don't know how to add the customer table to the query.

 

[Joe4]

Simply go into Design View of your query, right-click in the space where it shows you existing table, and select "Show Table".
Then select the Customer table from that list.
It may even automatically create the join between the two tables for you.

 

[DonnyF]

I have done that but don't see the relationships in the query design window.

 

[DonnyF]

In the main Relationships window the ID (primary key) from the Customer table is joined with CompanyName in the Workorder table.

 

[Joe4]

If you do not see the join between the two tables in the query, you can create it simply by dragging a line between the two fields it is matching on.
If you do not know how to do this, watch this video (around the 45 second mark): https://www.youtube.com/watch?v=qceAxjRciXI