using the UPDATE sql statement yu can update multiple records. for eg. Update authors Set name = "gorilla" this statement will update all author names to "gorilla" Look up the keyword UPDATE in the acces manual... ------ Ashok Hariharan http://www.unganisha.org ------