while not answering your select question, check out crud.archive: 
http://web2py.com/book/default/chapter/07?search=archive

it's pretty slick and does the archiving for you automagically.  now your 
query is still a problem....

Reply via email to