SQL and Query results don't Match

F

Filo

In a very simple query I entered that I only want to retrieve data for
product 200. After the query runs results show results for product 200 but
also for other products, and I don't understand why. When I export the data
to excel I only see the product 200 results as if the query worked fine. Why
is this happening?
 
R

Ron2006

I can't figure out what this sentence in your description means.

"After the query runs results show results for product 200 but
also for other products, "

If you are executing a display query, then executing it and showing
results are the same thing.

What are you looking at to "see" results?

Ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Data with no relationship, fall-out data from query 2
can't find the right query 0
Sumarize data in Query like in a Pivot Table 7
Running Balance (Debit and Credit) in Access 2007 3
Formatting date gives bad results in query 2
Top 5 by group 0
200 results per page 2

Top