Our database has a SQL backend and a Visual Basic Frontend for data entry. I often create reports via Microsoft Project. My question, in a query I am summing two integer fields, if their are no manhours for one of the fields it is left null. However, when I try to sum them it will not sum unless I add zeros in the null field. I really wanted to leave them blank if possible because it it easier to see if something is inadverately forgotten (admittedly not the best reason). Is there some syntax I can use for the null field when calculating or should I just make it default to zero?
Thanks for you help.
Thanks for you help.