Hi, I know this isn't solution to your problem, but my googling lead me to this page and I was having the same problem. I was trying to get the count of records in the report and kept inexplicably getting #error. All that was needs was to move the text box from the Page Footer to the REPORT Footer!