Not all data in fields is showing up in query

  • Thread starter Thread starter Chris.
  • Start date Start date
C

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

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%.
 
I must respectfully disagree with S. Clark; 5500 records isn't
"10% of what Access can handle" but more like 0.1%.
Click to expand...

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