Solved Subreport Not showing up in Print Preview

Nice!
I was trying to add the DESC to the union query SQL.
Probably did it wrong....
Thanks for the assist! Again.
Hi. You're welcome! Good luck!
 
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

Ah, I see. Order it by another field in the Record Source.
Thanks DB!!
 

Users who are viewing this thread

Back
Top Bottom