Anith,
I appreciate you working with me on this, but I need for you to dumb
it down a little further. If I'm trying to update a record that has
been changed, what kind of where condition would I be using? What
signifies that the record has changed?


"Anith Sen" <anith@bizdatasolutions.com> wrote in message news:<4TFqb.13433$Oo4.5024@newsread1.news.atl.eart hlink.net>...
> >> Second, if I'm correct, the default value only applies to new records
> should no value be pleased in that field. <<
>
> No, you can use it in your UPDATE statement as I have shown in my post.
>
> >> Also, what differentiates one record from the whole table? <<
>
> You have to use a proper WHERE clause to identify the rows which are
> affected by the UDPATE statement.