The SQL statement was not the problem... that's what I was trying to express when I said that I checked the SQL statement directly in MySQL... My error trap would have detected if it were the problem...

still not working with ur modification, thanks though...

Squirrelly1