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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Display unique date
- Thread starter sanjaych
- Start date
DJWheezyWeez
Technical User
Make a group for {table.activity} then go to the group selection editor and use {table.date} = maximum({table.date}, {table.activity}).
- Thread starter
- #3
Go to report->selection formula->GROUP and enter:
{table.date} = maximum({table.date}, {table.companyname})
...if you want only the most recent record per companyname. This assumes you have a group on company name. You should replace {table.date} with your actual date field, and {table.companyname} with your company name field.
-LB
{table.date} = maximum({table.date}, {table.companyname})
...if you want only the most recent record per companyname. This assumes you have a group on company name. You should replace {table.date} with your actual date field, and {table.companyname} with your company name field.
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question