D
Daniel Tinker
I have a subform (based on a query, in datasheet view) in
my main form, which may contain several items. I need to
summarise one of the fields on the subform, to appear as
an answer on the main form ie. if the answer to the
question for each item is YES, then the summary should
say YES, but if the answer to the question for any one of
these items is a NO, then the summary should say NO. So
far i have only been able to summarise the first line of
the datasheet subform using the expression IIf.
I would be grateful if anyone could help.
Daniel
my main form, which may contain several items. I need to
summarise one of the fields on the subform, to appear as
an answer on the main form ie. if the answer to the
question for each item is YES, then the summary should
say YES, but if the answer to the question for any one of
these items is a NO, then the summary should say NO. So
far i have only been able to summarise the first line of
the datasheet subform using the expression IIf.
I would be grateful if anyone could help.
Daniel