Fields with blank entries 1

[sblanche]

I have a table with 25 columns. Some columns will have entries (such as .25, .75, etc) and some will not. When I do a query to add the fields--

Total: [column 1]+ [column 2]+ [column 3] and so on--

as long as there is an entry in the column it adds fine. If there is a blank, it will not add properly. (I can add a zero and it will add ok but I don't want to have each empty field needing a zero). I read info on null values and figure that is the problem but I'm not sure how to apply a fix here.

Any help will be appreciated--

Thanks,
slb

 

[PHV]

Total: Nz([column 1],0)+Nz([column 2],0)+Nz([column 3],0) and so on--

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sblanche]

Great--That worked. Thank you so much. I saw something about the Nz but wasn't sure how to use it.