I thought there was a way to tell an sql statement to order by blah blah blah but to change to ascending/descending. I thought it was something like order by (ASC)ID. I also write VB and sometimes mix my code (try to) cuz I get confused. Can someone help me. I have pulling records based on the ID field, and i just want it to reverse the order.<BR>email jeffrey@schnelker.com