Prev: values in the AutoNumber field are not sequential, why?
Next: Help With First attempt at Database Relationships
From: jeffhill on 2 Apr 2010 21:34
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?
From: Arvin Meyer [MVP] on 2 Apr 2010 22:23
"jeffhill" <jeffhill(a)discussions.microsoft.com> wrote in message
news:A25B91A2-BC0D-445A-9AC9-834BAD68C4C8(a)microsoft.com...
>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


From: Duane Hookom on 2 Apr 2010 22:22
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.

--
Duane Hookom
MS Access MVP


"jeffhill" <jeffhill(a)discussions.microsoft.com> wrote in message
news:A25B91A2-BC0D-445A-9AC9-834BAD68C4C8(a)microsoft.com...
> 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?

From: John W. Vinson on 2 Apr 2010 22:38
On Fri, 2 Apr 2010 18:34:01 -0700, jeffhill
<jeffhill(a)discussions.microsoft.com> 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]
 | 
Pages: 1
Prev: values in the AutoNumber field are not sequential, why?
Next: Help With First attempt at Database Relationships