So the formula is okay and the order by botched things up, eh? ... Dang ... I thought I tried leaving that out .. Oh well ... I'll give it a whirl Rudy! Thanx! Ron L. -----Original Message----- From: Rudy_Limeback at maritimelife.ca [mailto:Rudy_Limeback at maritimelife.ca] Subject: Re: [thelist] Access & SQL use ORDER BY N1, N2,... where the N's are the position numbers within the SELECT list of the columns you want to order by in your case ORDER BY 1