If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SQL and Query results don't Match
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? |
#2
|
|||
|
|||
SQL and Query results don't Match
In your query criteria of that field, put Like 200.
"Filo" wrote: 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? |
#3
|
|||
|
|||
SQL and Query results don't Match
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 |
Thread Tools | |
Display Modes | |
|
|