Page 1 of 1

Calculated field for first date?

Posted: Thu Apr 21, 2005 12:38 pm
by Victor_(Guest)
I want to print a monthly statement that lists each invoice in the month with a typical description row that includes the invoice date. The problem: At the bottom of the invoice I would like to print the date range of the invoices, i.e., "This monthly statement inludes invoices from first_date to last_date." How do you capture and print the first date in a series of customer invoice records on a group footer line?

=> Calculated field for first date?

Posted: Thu Apr 21, 2005 12:59 pm
by kfleming
You would create a group total that is a minimum of the date field and then place the total on the group footer. It will show you the earliest date for that group.____Kathleen__R&R Support