OK, I have a calculated time average, based on detail data. I want to display two or more different average fields in the report footer, based on a text field in the record. In other words, I want an average number if the event occurred at location one, and a DIFFERENT average displayed if this event occurred at location two.
 So, in the footer I want:

Location one average: xx minutes
Location two average: yy minutes.

 I have played with the group expert, I have inserted IF statements, so that the records will be filtered based on location, and no results.

 Any suggestions would be appreciated.

Hi D:
 Unfortunately the formula I'm using (based on a calc of two other formulas) does not show up in the "Create Running Total Field" interface. So I cannot place it in the "Field to Summarize" box. Do you know how I can get my formula to show up?
 Also, you say to choose: "Evaluate=use a formula." What form would that formula take? 

 Than you very much in advance.