DBL Registered User. Local time Today, 22:59 Joined Feb 20, 2002 Messages 659 May 12, 2005 #1 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!
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!
S ShiftyJaffa Registered User. Local time Today, 21:59 Joined Nov 10, 2004 Messages 36 May 12, 2005 #2 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
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
