Summing/Page Breaks

[Beth B.]

Hello all. Is there a way to perform a function on a field
that is contained in the detail section of a report and
have the result print as a footer for each of those
records, when that is not the primarily sorted record for
the detail field? Example: My report detail sorts by
product leader, and contains data reflecting the date an
item was received, the item description, and what customer
the item is from.
The report needs to remain separated by product leader,
but I need to perform a calculation on the date received
field to give me how many days it's been in-house for each
date. I know how to do this, but since product leader is
my main sort, it is only doing the function overall, not
for each date.
In addition, I need to page break for each product
leader (which is why I set that as the primary sort). Is
there a way to page break at each product leader without
it being my primary sort that would be simpler than trying
to calculate each date?
Any advice would be much appreciated.

 

[Sue Mosher [MVP-Outlook]]

Maybe you should be asking this in an Access forum or one for whatever
product you're using to generate the report. I don't see that it has
anything to do with Outlook.

 

[Beth B.]

Sue -

Thank you so much! It is an Access question. It's been
one of those days : - )

Beth