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

[theDBguy]

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!

 

[Weekleyba]

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.

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:

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.

 

[theDBguy]

Check this one...

 

[Weekleyba]

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

 

[theDBguy]

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

Yup. Got to do what you can...