Hi
My question relates to designing a query. I have made a field in the query that adds the value in three other fields, in the form 'Totals: [field1] + [field2] + [field3].
This works fine when all three fields have values, but if one or 2 of the fields are blank it comes out with an answer of blank even if one or two of the fields do have values in them. Any ideas how I can fix this?
Thanks much
Michael
My question relates to designing a query. I have made a field in the query that adds the value in three other fields, in the form 'Totals: [field1] + [field2] + [field3].
This works fine when all three fields have values, but if one or 2 of the fields are blank it comes out with an answer of blank even if one or two of the fields do have values in them. Any ideas how I can fix this?
Thanks much
Michael