Below is the SQL I have on a query. This query is made up of 4 other queries. If any of the fields = zero how
can I make a zero appear? Right now the field just shows blank if it is equal to zero. I really want the zero to
appear on a form that I have created from the query. Thanks for all help.
can I make a zero appear? Right now the field just shows blank if it is equal to zero. I really want the zero to
appear on a form that I have created from the query. Thanks for all help.
Code:
SELECT MonthlyEcnReceived.Received, MonthlyEcnImplemented.Implemented, [MonthlyEcnW/Structure].[W/Structure], [MonthlyEcnW/StructureImplemented].Implemented
FROM MonthlyEcnReceived, [MonthlyEcnW/Structure], MonthlyEcnImplemented, [MonthlyEcnW/StructureImplemented];