Hi All,
In an AccessXP report in a Group Footer I have the following in a
textbox and I don't think its working.
Question; Is AccessXP smart enough to know to first sum up all the
values of
[DaysToReferral] and count how many before it calculates the average
for only those records
that met the criteria? or is it just capturing the last value for
that grouping and calculating it.
=Avg(IIf([dtMonth]=Forms!frmMainM enu!bxComprMth And [dtYear]=Forms!
frmMainMenu!bxP riorYrDte And [CatType]="DRef",[DaysToReferral],0))
thanks
bobh.
In an AccessXP report in a Group Footer I have the following in a
textbox and I don't think its working.
Question; Is AccessXP smart enough to know to first sum up all the
values of
[DaysToReferral] and count how many before it calculates the average
for only those records
that met the criteria? or is it just capturing the last value for
that grouping and calculating it.
=Avg(IIf([dtMonth]=Forms!frmMainM enu!bxComprMth And [dtYear]=Forms!
frmMainMenu!bxP riorYrDte And [CatType]="DRef",[DaysToReferral],0))
thanks
bobh.
Comment