Access Query Question

Question

I looked at the directions on creating a query.  Chose 3 columns from the table I created.  I put in the first column and then chose 2 other columns that I wanted the result to come from.  I saved the query and when I hit run, received an error 13 - data type mismatch in criteria expression.  How do I correct this?

Answer 1

I was able to get the initial issue cleared but now have a new question.  What I am trying to do is set up a query whereby a search item is entered and then the results show the location of where to find the item.  Can anyone help with this?

Answer 2

1. Did you enter anything in any of the criteria boxes under any of the tables fields?
2. When you open the query in Design mode, does each column have a field and table specified?

You can open the query in SQL mode and copy the SQL text into a Reply box in this forum also so we can see what the query is doing. I recommend you do that.

Answer 3

Corrected the error 13 by putting "Name" in the criteria box.  However, still not the type of query I am looking for.  Should the query be a "search" box tied to the columns in lieu of a query?

Answer 4

SELECT [Aisle and Shelf].[Product Name], [Aisle and Shelf].Shelf
FROM [Aisle and Shelf]
WHERE ((([Aisle and Shelf].[Product Name])="Name") AND (([Aisle and Shelf].Aisle)="Number") AND (([Aisle and Shelf].Shelf)="Right")) OR ((([Aisle and Shelf].Shelf)="Left"));

Answer 5

Hello AA Raphae,

>>What I am trying to do is set up a query whereby a search item is entered and then the results show the location of where to find the item.  Can anyone help with this?

What's your data source? What's your condition and what's result you want to get?

You said that the error 13 is corrected, so What's the current issue?

I would suggest you provide some simply data to illustrates the desired result or behavior.

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].