D
dudess
i have a query that sums the values of various number
fields. when i try to create a sum field in the query, i
get no results unless all fields contain some number,
even if it is a 0. i do not want the field to have a
zero value for when it is used elsewhere. (on a report).
so my ? is, is there any way to get a field to have a
zero value, but not show it in a report? or else some
way to get the sum feature of the query to include blank
fields?
any help would be appreciated.
fields. when i try to create a sum field in the query, i
get no results unless all fields contain some number,
even if it is a 0. i do not want the field to have a
zero value for when it is used elsewhere. (on a report).
so my ? is, is there any way to get a field to have a
zero value, but not show it in a report? or else some
way to get the sum feature of the query to include blank
fields?
any help would be appreciated.