Min/Max Date-Time Stamp Sorting
Posted on 1998-12-11
I have an ODBC Access data source that has data structured in this format: Product ID, Value 1, Value 2, Value 3, Date-Time Stamp of when values were recorded. The product ID repeats several times as readings are taken at different times - i.e., I have multiple entries for each ID. I want to report in summary style, only the minimum and maximum date-time records with associated values in Crystal Reports. Can anyone provide me an explanation that would allow me to summarize in this fashion?