Success. I had to fugure out how to use multiple criteria (the link you suggested really helped) and discovered that both fields referenced in the criteria had to be present in the footer where the DLookUp function was being used. Thanks again, hopefully for the last time. I guess I must conclude that arrays can't be built or referenced from invisible report sections.