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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Maximum date
- Thread starter mart10
- Start date
IanWaterman
Programmer
In top menu Report select "Selection Formulas" -> Group.
datefield = maximum(datefield)
This will suppress all other records but they will still be in recordset and will affect summaries.
You can still use Running Totals and use the same condition above to restricy RT recordset.
Failing that you will need to can use a SQL expression which returns the max date. You can then use this in your record selection.
NB it could be slow to run as whole dataset will come back and filtered against this expression within report.
Ian
datefield = maximum(datefield)
This will suppress all other records but they will still be in recordset and will affect summaries.
You can still use Running Totals and use the same condition above to restricy RT recordset.
Failing that you will need to can use a SQL expression which returns the max date. You can then use this in your record selection.
NB it could be slow to run as whole dataset will come back and filtered against this expression within report.
Ian
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question