View Single Post
  #3  
Old April 3rd, 2010, 03:23 AM posted to microsoft.public.access.gettingstarted
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default what causes, "no results returned"

"jeffhill" wrote in message
...
I have written a query to display a list of customers in my database (MS
Access)
When I ran the query the DBMS displays no records. I know there should be
records of at least 10 people. What might have caused this?


Something in either a join or where clause is filtering out your records.
Start with 1 table and add tables or criteria 1 at a time and check the
results as you go.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access