Hi all,
Hope this is a quickie.
I have a subform that may contain quantities of stock, or no records. I need to take an average value from this subform.
I'd like to return a count of the number of lines in the subform because if there are no records, I can't obtain an average. Doing a count of the number of records isn't working for me because if there is no record in the subform, I'm not getting "0" I'm just not getting a value. Is there a straightforward way of doing this?
Cheers,
Pete
Hope this is a quickie.
I have a subform that may contain quantities of stock, or no records. I need to take an average value from this subform.
I'd like to return a count of the number of lines in the subform because if there are no records, I can't obtain an average. Doing a count of the number of records isn't working for me because if there is no record in the subform, I'm not getting "0" I'm just not getting a value. Is there a straightforward way of doing this?
Cheers,
Pete