SBS - My solution and Neil's are basically identical except in a few minor areas. He creates a recordset, I don't. I connect directly to the database. He connects through a Data Set Name (DSN). We have a slightly different order to a few of the lines and, of course, our variable names, including asp and sql var names are a little different. Other than those minor differences the solutions are the same. You should get a good feel for this by looking at the similarities of both solutions.Oh...and I think there are some single quotes missing in Neil's sql statement. Be careful there....as I mentioned earlier, if you are going to have an error, it will be there...I have made that same mistake dozens of times.Edited By: tekprof on 2005-12-9 8:52:3
