Not all data in fields is showing up in query

[Chris.]

I'm new to Access and I'm having a problem with data. I have 5,500 people in
a database which I can sort and filter. The problem is that I've asked for
a query to show all members, including name, address, job title, etc. All
fields are filled in if you look at each individual record, but for some
reason, the query report only shows complete data for about 3,700 of them.
The remaining people have names, but parts of their records are missing
(city, job title, etc.).

Is the file too big for Access to show everything?

 

[Arvin Meyer [MVP]]

You probably have a criteria in the query which limits what you see. 5,500
records are a pittance for Access. I have 1 database with 6 million records.

 

[S.Clark]

No. 5500 is about 10% of what Access can handle.

Post your table structure and SQL Statement, and we'll analyze what your
issue is.

 

[John W. Vinson]

I'm new to Access and I'm having a problem with data. I have 5,500 people in
a database which I can sort and filter. The problem is that I've asked for
a query to show all members, including name, address, job title, etc. All
fields are filled in if you look at each individual record, but for some
reason, the query report only shows complete data for about 3,700 of them.
The remaining people have names, but parts of their records are missing
(city, job title, etc.).

Is the file too big for Access to show everything?

Fix the error in your query. For help in doing so, please open it in SQL view
and post the SQL text here. My guess is that you have a Join to some table
which doesn't have matching records for the missing people; there are lots of
other possibilities!

I must respectfully disagree with S. Clark; 5500 records isn't "10% of what
Access can handle" but more like 0.1%.

 

[Arvin Meyer [MVP]]

No. 5500 is about 10% of what Access can handle.

Actually way less than 1% of what Access can handle.

 

[David W. Fenton]

I must respectfully disagree with S. Clark; 5500 records isn't
"10% of what Access can handle" but more like 0.1%.

I'd go with two orders of magnitude beyond that.