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

Weekleyba

Silver Supporter
Local time
Today, 14:31
Joined
Oct 10, 2013
Messages
309
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

Weekleyba

Silver Supporter
Local time
Today, 14:31
Joined
Oct 10, 2013
Messages
309
Ah, I see. Order it by another field in the Record Source.
Thanks DB!!
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom