RE: Appending to a data record

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sure. It would look something like below. A is the table name and O is the
field name.

UPDATE A SET A.O = Trim([O] & " " & "New text");

& " " & puts a space between the old and new text.

The Trim() function gets rid of any leading or trailing spaces. For example
if the O field was null or empty, there would be a space before New text.

I haven't tried this with a Memo field. Also remember that Text fields run
out at 255 characters.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"BillA" wrote:

I need to do a select query based on a date and then add a note to a field in
the database. In some cases there is already data in the field so I want to
append the data that is there. All I've seen is appending to another table.
So is it possible and do I use an append query to do it?

Thanks in advance for any help
Bill Alsdorf
.

Relevant Pages

  • Re: the function " =TRIM( )"
    ... =trim() removes duplicated internal spaces and leading and trailing spaces. ... If you want to get rid of all the spaces: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Mem table with variable length strings?
    ... Use String, set performance to mtpSmall, and use Trim to get rid of ... leading or trailing spaces. ...
    (borland.public.delphi.thirdpartytools.general)
  • getting rid of warning dialog
    ... database. ... there is an annoying warning dialog that pops up, and I'd like to get rid of ... You are about to append 1 row.Once you click Yes, ... How can I get rid of this? ...
    (microsoft.public.access.gettingstarted)
  • Re: Corrupted Record
    ... >re-enter, but when I highlight and ask it to delete is says ... >How do I get rid of this record? ... table scan) to append the good data. ...
    (microsoft.public.access.forms)
  • Re: Implementing keygroup/3
    ... Get rid of all occurrences of is_member, append and reverse! ... You do that by building your lists in the right order (append ...
    (comp.lang.prolog)