This seems rather trivial. I have a query joining two tables: tblSegments & tblSubmittals. The query I'm creating totals weights for Submittals based on a segement. The problem I'm having is that there are Segments that are created that don't have weight entered for them yet in the submittals table. The query of course leaves these out, but I would like to seem them, with a total weight of zero. This is the expression I'm using for the field I want in my query:
DetWgt: Sum(Nz(([dbo_tblSubmittals].[DetWgt]),0))