First of all, you are an awesome teacher--I started off knowing nothing about Access and I have learned so much already! I came back to this video to review form footer totals--I am trying to use the average and count aggregate functions.  I have a report that displays RateIn, RateOut, and Margin (which is a calculated field) for all of my active consultants, along with FirstName, LastName, and Status.  I tried to create a text box for the average margin in my form footer by copy pasting the Margin text box and adjusting the control source to =Avg([Margin]), as well as a count for number of active consultants by doing the same thing only changing control source to =Count([Margin]). When I look in print preview, these fields come up as #Error. Have I done something wrong? Or does it have something to do with either the Margin field being a calculated field or these fields being stored as currency? Thank you for your wisdom!

---

Reply from Alex Hedley:

Are these controls in the Groupings of the Report?