Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-27-2019, 10:01 AM   #1
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 104
Thanks: 66
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
Not all records displayed

I have 2 select queries that run to populate an access report whenever the report is opened.

The first query gathers facility information and the second gathers all sub records for that facility based on specified criteria.

The issue is whenever I open the report, its only displaying 3 of the 5 sub-records.

If I manually run the queries, or manually open the sub-report, all 5 sub records are displayed in the table, but no matter what I do, I can only get 3 to display when I just open the main report.

The sub report is not linked to the main report in anyway, that I am aware of anyway.

any thoughts ???


After some more investigation, if I look at the report in Report View, everything displays correctly, however if I look at it in Print View, only 3 records are displayed.

As I am exporting this to a PDF file on creation, it is only doing the 3 records


Last edited by NearImpossible; 10-27-2019 at 10:29 AM.
NearImpossible is offline   Reply With Quote
Old 10-27-2019, 10:43 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,387
Thanks: 13
Thanked 4,123 Times in 4,055 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Not all records displayed

Is there any code or macro running behind the report? There are events that fire in some views but not others.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 10-27-2019, 10:45 AM   #3
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,387
Thanks: 13
Thanked 4,123 Times in 4,055 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Not all records displayed

I'd also check the master/child link properties of the subreport control, though I'd expect that to affect all views.

__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 10-27-2019, 10:52 AM   #4
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 104
Thanks: 66
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
Re: Not all records displayed

Quote:
Originally Posted by pbaldy View Post
Is there any code or macro running behind the report? There are events that fire in some views but not others.
No Code running in the back ground


Quote:
Originally Posted by pbaldy View Post
I'd also check the master/child link properties of the subreport control, though I'd expect that to affect all views.
Sub is not linked to the master, they are each populated from their own query, just displayed on 1 page
NearImpossible is offline   Reply With Quote
Old 10-27-2019, 10:58 AM   #5
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,387
Thanks: 13
Thanked 4,123 Times in 4,055 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Not all records displayed

Can you attach the db here?
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 10-27-2019, 10:59 AM   #6
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 104
Thanks: 66
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
Re: Not all records displayed

I just deleted the report, made a blank report and then added each query as as a sub report and its working.

I think originally I used the report wizard to make a report based off the first query and then dragged the second query onto that report to make the sub report. Guess access didn't like that.....
NearImpossible is offline   Reply With Quote
Old 10-27-2019, 11:00 AM   #7
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,387
Thanks: 13
Thanked 4,123 Times in 4,055 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Not all records displayed

Glad you got it working.


__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
NearImpossible (10-27-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
# of Records does not equal the displayed # ChapJohn Tables 8 07-20-2012 08:41 AM
All records are not being displayed jon jomaco Forms 1 02-18-2008 05:13 PM
Number of records displayed Crampton Forms 4 02-11-2004 08:29 AM
No records displayed by form MadCat Forms 2 08-20-2003 03:22 AM
0 Records Displayed Dominic84 Forms 7 02-04-2003 08:23 AM




All times are GMT -8. The time now is 12:40 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World