R Randal Mar 8, 2004 #1 Is it possible to create sums in a group footer for only the data that meets a certain criteria?
M Marshall Barton Mar 8, 2004 #2 Randal said: Is it possible to create sums in a group footer for only the data that meets a certain criteria? Click to expand... Yes. There are several ways to conditionally count or sum values. =Count(IIf([field1] = "ABC", 1, Null)) =Sum((IIf([field1] = "ABC", [field2], 0))
Randal said: Is it possible to create sums in a group footer for only the data that meets a certain criteria? Click to expand... Yes. There are several ways to conditionally count or sum values. =Count(IIf([field1] = "ABC", 1, Null)) =Sum((IIf([field1] = "ABC", [field2], 0))
R Randal Mar 8, 2004 #3 Thanks Marshall. Marshall Barton said: Randal said: Is it possible to create sums in a group footer for only the data that meets a certain criteria? Click to expand... Yes. There are several ways to conditionally count or sum values. =Count(IIf([field1] = "ABC", 1, Null)) =Sum((IIf([field1] = "ABC", [field2], 0)) Click to expand...
Thanks Marshall. Marshall Barton said: Randal said: Is it possible to create sums in a group footer for only the data that meets a certain criteria? Click to expand... Yes. There are several ways to conditionally count or sum values. =Count(IIf([field1] = "ABC", 1, Null)) =Sum((IIf([field1] = "ABC", [field2], 0)) Click to expand...
