I have a bunch of small queries that total dollar amounts up. I am trying to put all of the totals queries into one big query so I can create a report. It works fine for all of the queries that have a $$ amount in the total. When I add a query where the $$ amount is blank, the entire query comes back with nothing. Why does the empty $$ amount cause the query to show nothing? Is there an easier way to get all of these queries into a report? Thanks!