My access report is not showing all the data. The query fetches all the records ..... but the report shows only some records. If I do top 50 in my query, the report shows 50 records. If i use top 100, report still shows 50 records. I tried to search any filters in the report but couldn't find any. Although when I use page break, all the records are shown. Any idea what could be the problem??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Report not showing all the data.
- Thread starter nik11
- Start date
- Thread starter
- #3
I have never heard of an issue like this unless the user was viewing something other than Print Preview or Printing.
What code did you use to show 56 records per page?
Are there any subreports involved?
I assume the Filter property is blank.
Duane
Hook'D on Access
MS Access MVP
What code did you use to show 56 records per page?
Are there any subreports involved?
I assume the Filter property is blank.
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
- Locked
- Question
- Locked
- Question