update sql code check

[Jen0dorf]

Hi



My database is now working so I'm tidying it all up for my own satisfaction

have a single table named deceased with two fields notes and notes_2

some fields in notes_2 are in notes and some are not.

The ones that are in both fields I'll have to check manually but the other ie the ones that are not I could update?

I created this sql code

UPDATE tblDeceased SET tblDeceased.Notes = [tblDeceased]![notes_2]
WHERE (([tblDeceased]![Notes] & ""=""));

The idea is that if the field in notes is empty then update the field

I'd also like to delete the field in notes_2 after the update but can't see how to do it.

I do however have a niggle that my logic is wrong somehow

will the update run record by record to do I have to specify that the record ids have to be the same or am I confusing myself?

thanks

Ian

[JoeM]

Your code seems to work fine for me. If it is not working for you, make sure that the Notes field really is blank and doesn't contain a space or some other character.

To delete the Notes_2 field, simply have another Update Query that set the value of Notes_2 = "" if Notes and Notes_2 are equal.

[pbaldy]

I'd expect this to work to set the second field:

UPDATE tblDeceased SET tblDeceased.Notes = [tblDeceased]![notes_2], [tblDeceased]![notes_2] = Null
WHERE...

or setting to "".

[Jen0dorf]

Hi

thanks both for the assist

Ian