Okay so I have a query and one of the columns shows the totals of two other columns in different queries.
The problem is that when I run this query when the total is zero it appears a blank field. I need a zero to appear instead of a blank.
I'm guessing I need to build an IFF function under that column in the design view of the query? If that's the case what would the whole function look like? Or if there another way please let me know.
Thank you!