-- [ Picked text/plain from multipart/alternative ] how can i get the average of the last 3 records entered by a particlar user? or even just the last 3 records and do the math elsewhere. idea along the lines of select avg(steps) as steps from tblSteps where user='100' and record=the last 3 thanks --