DBL
05-12-2005, 08:44 AM
How can I pull the last two values, grouping by property id, so I can compare them? I can use Max to get the last value but not sure how to get the previous one too!
|
View Full Version : Top Two Results DBL 05-12-2005, 08:44 AM How can I pull the last two values, grouping by property id, so I can compare them? I can use Max to get the last value but not sure how to get the previous one too! ShiftyJaffa 05-12-2005, 09:16 AM If you bring up the properties of the query and change the top values property to 2. Don't use max, instead sort by your value (descending). Paul |