what causes, "no results returned"

  • Thread starter Thread starter jeffhill
  • Start date Start date
J

jeffhill

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?
 
I expect someone could help if they could see your tables, relationships,
data, and the SQL view of your query. Since we aren't privy to any of this,
we have to rely on you to provide all of the information that might be
significant.
 
jeffhill said:
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?
Click to expand...

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.
 
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?
Click to expand...

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.
 
Back
Top