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
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.