Skip to Content
0
Former Member
Oct 01, 2009 at 05:19 PM

Associate a record name with a running total in Report Footer

21 Views

Please Help!

I have a report that returns records for the most recent order recieved by vendor.

The page header displays Vendor, Contact, Order #, and date

I did a group by Vendor

I used a running total on the order date

with a summary of minimum

that evaluates on change of group

Reset never

This returns the last order date for the vendor with the oldest order

How can I get the vendors name that is associated with the oldest order date to display in the Rport Footer.