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.