I have a report based on a query. It is a simple listing of returned
merchandise that has been repaired and shipped. I have a text box in
the detail section that calculates the total days the merchandise has
been in house (Subtracting date shipped from date received).
What I would like to do is have one field that then adds up all the
listed units' date differences and averages them. I would like to
display this at the bottom of the Date Diff column. My problem is 1)
how to keep a running sum and average the values and 2) where do I
place the field in the report. It seems that it can't be in the detail
section because that would not give me a summation of the entire
column.
Thanks for the help in advance.
Also, I read where I can create a crosstab query and export it to
Excel. Would this solution be easier for my situation? If so, how do
you export the query to Excel?
Troy
merchandise that has been repaired and shipped. I have a text box in
the detail section that calculates the total days the merchandise has
been in house (Subtracting date shipped from date received).
What I would like to do is have one field that then adds up all the
listed units' date differences and averages them. I would like to
display this at the bottom of the Date Diff column. My problem is 1)
how to keep a running sum and average the values and 2) where do I
place the field in the report. It seems that it can't be in the detail
section because that would not give me a summation of the entire
column.
Thanks for the help in advance.
Also, I read where I can create a crosstab query and export it to
Excel. Would this solution be easier for my situation? If so, how do
you export the query to Excel?
Troy