I have an expense database I created for a client where on the form I set tax fields to default to zero so that I don’t end up with NULL values when I try to do my calculations. I created a query to pull together all the information - it all looks great in the query - all my zeros are in the tax columns where they should be and all my calculations within the queries work fine. But then I create a report with that query and the report replaces all of my zeros with NULL and now none of my calculations are working.
I have already posted questions about how to get the report builder to insert a zero where there is a NULL and have not come up with any solution for that either.
Any help would be greatly appreciated.