----- Original Message ----- From: Gordon Stewart I have a database set up, with one of the fields is a month -
"200611" = November 2006 "200610" = October 2006 "200609" = September 2006 I was wondering, I know how to sort descending etc.. - Is there a way, to (add to an existing search criteria).. select all records in the last XX months.. IE, If I only wanted the last 2 months, it will only select records in October & November 2006.... or September also - if I want 3 months... (I have records going back to April 2006) Im guessing the 'unique' function will be used, but im not sure how to select XX months..... Hi Gordon, Couldn't you just use DESC LIMIT 2 or where limit is a variable. Regards, Bob Exton.
