thanks for your replies. the orderno field is a text field, i am using an access database so how do i proceed from here?