View Single Post
  #4  
Old April 3rd, 2010, 03:38 AM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default what causes, "no results returned"

On Fri, 2 Apr 2010 18:34:01 -0700, jeffhill
wrote:

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?


An error in the query, or an error in the data.

Since we can't see either it's a bit hard to be more specific. Perhaps you
could open the query in SQL view and post the SQL text here, and indicate a
sample of the data you're expecting to see.
--

John W. Vinson [MVP]