Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

First and last in a group?

Status
Not open for further replies.

JRandallC

Technical User
Sep 17, 2002
10
0
0
US
In a report (Impromptu Series 7), I have a list of accounts with transactions on that account. I need to create a custom calculation that will return me the date of the first transaction for that account (earliest date) and another calculation that will return me the date of the last transaction (most recent date). Can this be done in a calculation? Would a macro need to be used? Thanks for any help.

Randall
 
Try using the minimum and maximum summary functions Gary Parker
Systems Support Analyst
 
Cool. Thanks. I looked all through the functions, but forget about those summary functions sometimes.

Randall
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top