Solved Subreport Not showing up in Print Preview (1 Viewer)

Weekleyba

Registered User.
Local time
Today, 04:06
Joined
Oct 10, 2013
Messages
586
DBguy,
Hopefully last question as I implemented all info into the db.
On problem has surfaced, and this when the imported table has a "0" in the data.
We took care of the null in the table and placed a 0 in it's place but when there is a 0 in table, the union query not brings both zeros to the report.
See below for Equip Prior Year.
1582315813014.png


The Record Source is:
SELECT TOP 1 * FROM EQUIP_FED_PriorFY_Q2 ORDER BY [SumOfSumOfFunds Available] DESC;

Where the union query is EQUIP_FED_PriorFY_Q2 which generates the following:
1582315977730.png


Is there an easy way to eliminate the double zero in this case?
I attached the revised db
If you select Berthold Health Center and Open Report, you will see the double reading on Equipment Prior Year Federal.

Thanks for the help.
 

Attachments

  • DFM Funding Database 10.zip
    318.9 KB · Views: 96

theDBguy

I’m here to help
Staff member
Local time
Today, 02:06
Joined
Oct 29, 2018
Messages
21,322
Check this one...
 

Attachments

  • DFM Funding Database 10.zip
    362.6 KB · Views: 102

Weekleyba

Registered User.
Local time
Today, 04:06
Joined
Oct 10, 2013
Messages
586
Ah, I see. Order it by another field in the Record Source.
Thanks DB!!
 

Users who are viewing this thread

Top Bottom