The report is not displaying all the records from the table.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could somebody help me out on fixing the problem I have on dispalying all the records in a report that is bound to a table
I have Ms-Access 200 installed on my machine and it seems like ther is a bug on it. The report some time is displaying all the records and sometime not, no matter how may records are in the table, for example when there is 884 records, it displays only 831 while when there is 889 records it displays everything
Any help is very much appreciated please

thank
Jorika
 
If the report is bound directly to the table (not a query with multiple
tables or any criteria), and the number of records is inconsistently wrong,
there is a good chance that you have a corrupted index.

See:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
The 2nd section of the article is:
Symptom: Number of records varies, depending how on how the data is
sorted

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Jorika said:
Could somebody help me out on fixing the problem I have on dispalying all
Click to expand...
the records in a report that is bound to a table.
I have Ms-Access 200 installed on my machine and it seems like ther is a
Click to expand...
bug on it. The report some time is displaying all the records and sometime
not, no matter how may records are in the table, for example when there is
884 records, it displays only 831 while when there is 889 records it
displays everything.
 
Back
Top