Good Morning,
I have a query with a field(Not sure what the field is called) that i have the query make on the fly. The field has this formula in it "YTD: [Qtr1Final]+[Qtr2Final]+[Qtr3Final]+[Qtr4Final]" which works perfectly as long as I have values in each field in the formula. I dont really know how to fix this the best way but am sure if those fields had "0" in them if no other value is present then my formula would work.
Thanks for all the helpAttachment 33086Attachment 33087Attachment 33088