Total newbie question

[chiefsfan1018]

=DSum("[CountOfOrder Number]","QryCusto mers bfg","[Major] = 'Carrier' ")

Working in access 2000, this is for a value in my form, it works fine as long as the query it refers to returns a record, if it does not I get nothing, I am needing it to return a zero.

Sorry if this is a stupid question.

[MindBender77]

=DSum("[CountOfOrder Number]","QryCusto mers bfg","[Major] = 'Carrier' ")

Working in access 2000, this is for a value in my form, it works fine as long as the query it refers to returns a record, if it does not I get nothing, I am needing it to return a zero.

Sorry if this is a stupid question.

You could try this. Note, it is untested:
=iif(DSum("[CountOfOrder Number]","QryCusto mers bfg","[Major] = 'Carrier' ","",0))


Bender