By the way, I changed your thread title to something more meaningful than "Report".
Thanks. Unfortunately that's not going to work for me. =DateDiff("d",[AC],[AQ]) gives me the time difference, but I need to add all those lines up and * that number to get the Sum. You can see that I was trying =Sum([TotalDays]) on the bottom but it's not working. I know I can put my output in excel, highlight and get the sum, but looking for a way to add it to that text box
Well, you can't sum a calculated control:
http://support.microsoft.com/kb/207763
I'm not clear on how what I posted would give you anything different than what you were trying to do.
Basically it looks like it's not going to work. From what I understand is there is really no place holder. In Excel everything has a place (A1, b12 Etc). This is just showing a calculation.