View Single Post
  #2  
Old July 10th, 2008, 01:21 PM posted to microsoft.public.access.queries
Golfinray
external usenet poster
 
Posts: 1,597
Default 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?