append to noted field

[ODBCERRORKING]

is this an easy tasks can this be ran by a some sort of update qry? i have a field called notes on a user form that writes the field "notes" we are a billing agency i would like to know how to append a note to the users for that particlar day but if i update in that field it will overwrite anthing that is currntly in the notes field is there anyway to update to the end of the test that the user already has poulated ?

 

[tlbroadbent]

Update table
set notes = notes & vbcrlf & "more notes"

You may want to use 2 CR and LFs. If you want to get the best answer for your question read faq183-874.

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[ODBCERRORKING]

THAT WORKED GREAT BUT HOW DO I PUT A SPACE BETWEEN THE OL AND NEW NOTE I JUST UPDATED?

 

[tlbroadbent]

Update table
set notes = notes & " " & "more notes"
If you want to get the best answer for your question read faq183-874.

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[ODBCERRORKING]

THAT DID NOT WORK WHAT IS THIS vbcrlf ? ALL I WANT TO DO IS APPEND TO A NOTES FIELD AND PUT A SPACE BETWEEN THE OLD AND NEW NOTE BASED ON SOME CRITERIA. THIS IS AN ACCESS DATABASE WITH LINKED SQL TABLES BEING USED AS A DATASTORE.
I AM NOT A PROGRAMMER HOW DO I AN UPDATE QRY IN ACCESS TO DO
THIS
EXAMPLE:

UPDATE T_COLLECTION_RECORDS
THE "NOTES" FIELD I WANT TO APPEND NEW DATA TOO
WHERE "STATUS_CODE" = SKT

 

[tlbroadbent]

Pleae be explain what "THAT DID NOT WORK" means. PLease use good netiquette and type in mixed case. It is difficult to read messages in all UPPER case letters. Thanks.

Do you want to put a space or line feeds between the old and new notes? The first query uses vbcrlf to insert a carriage return (CR) and line feed (LF). The 2nd inserts a single "space" which is what you requested. Note you may need to use chr(13) & chr(10) for the CR and LF rather than the vbcrlf. It depends on how you build the query. If you want to get the best answer for your question read faq183-874.

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[ODBCERRORKING]

Sorruy about that just frustrated like i said not a programer this stuff just does not come easy to me

what is this vbcrlf funtion that you are talking about?
all i am trying to do is this run an update qry where a new note is gonna be appended to the notes field opposed to writing over it

notesld note <space> new note

 

[tlbroadbent]

The code I provided does what you want! vbcrlf is a VB constant not a function. I explained that it is a combination of carriage return (CR) and line feed (LF). Please reread my replies.

It would be helpful if you would post the VB code that executes the SQL update statement. If you want to get the best answer for your question read faq183-874 and thread183-468158.


Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[ODBCERRORKING]

ready to outsource should have no business even wasting your time still dont understand

 

[ODBCERRORKING]

SELECT T_Collection_Records.[Status Codes], T_Collection_Records.Notes
FROM T_Collection_Records
WHERE (((T_Collection_Records.[Status Codes])=&quot;SKT&quot)

IS THIS THE CODE YOU WERE TALKING ABOUT POSTING ?

 

[tlbroadbent]

I would agree about outsourcing. You want to update a table and you've posted a SELECT query. Tek-Tips is forum for professionals who have some idea about what they are doing. It's obvious you don't fit the description. If you want to get the best answer for your question read faq183-874 and thread183-468158.


Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[ODBCERRORKING]

iv been saying that the whole time pro! programers are a diffrent breed. ok how much should i pay for that sort of funtioality where i click a button a prompt comes up and asks me to put in new note. then appends the new note. i am a data analyst clean data all day in which i was forced into my position of supporting sql 2000 server and ms access frontend for a collection agency where we let all our support go. good move! i pretend to know access fairly well can create forms. sumforms,tables,macros just dont know too much about modules or stored proceures where is a good learnig site/tool to learn access programing?