showing most recent result only

C

Carlee

Hi there,
I have a report that shows all test results over time. I want to produce a
report which shows only the most recent test results, not the entire history.

What is the most efficient way of accomplishing this?
 
S

Steve Schapel

Carlee,

It depends what you mean by "most recent". Do you have a Date/Time
field or some such in the data which determines this? Possibly the
easiest way is to sort the records DESC in the query that your report is
based on, and use the TOP 1 predicate to get the most recent.
 
Top