Sum calculated field on Report

[54.69.6d.20]

I'm looking to get a Sum of the column Total Days. Is that possible?

[pbaldy]

One way:

=Sum(DateDiff(...))

[pbaldy]

By the way, I changed your thread title to something more meaningful than "Report".

[54.69.6d.20]

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

[pbaldy]

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.

[54.69.6d.20]

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.