"If (Photo Dates = Daily Sheet::Photography Date: and Daily Sheet::Church ID = CHURCH ID; Daily Sheet::Number of Sits ; 0 )"
(photo dates is a repeating field that will match
Daily Sheet::Photography Date:
Church ID is not a repeating field in either file
number of sits is not a repeating field either, but the field this calculation is a repeating field.
the formula works perfect only for the first repating field. the other 32 do not. any thoughts?
feel free to email me @ medinaofficework@aol.com
