I'm using the Nz function in a query to return a 0 in some fields when there is nothing in a field. I do so cause I want to sum these fields and I get an error because of the null values if I dont.
My problem is, when I sum the values, it sums them as if they were text values, ... If i have 5 + 5 + 0 + 5 + 0 it returns 55050,... I need to have 15.
Here is my Query
SELECT Nz([Field20],0) AS Chapt_A, tblVehicules.Field2, tblVehicules.Field3, Nz([Field22],0) AS Chapt_B1, Nz([Field23],0) AS Chapt_B2, Nz([Field25],0) AS Chapt_B3, Nz([Field26],0) AS Chapt_B4, Nz([Field29],0) AS FAQ34, Nz([Field30],0) AS SurprimeCan, ([Chapt_A]+[Chapt_B1]+[Chapt_B2]+[Chapt_B3]+[Chapt_B4]+[FAQ34]+[SurprimeCan]) AS TotalPrVehicule
concatonate is just to join all text,
perhaps in this section
replace each calculation in your SQL with the actual formula i.e. Nz(field20,0) in place of your name holder