What is the symbol for a character return in an Access query?

[ajaeger]

My syntax is:

SELECT '---NOTE1---' & InterimNotes & '---NOTE2---' & ACNotes as COMBINED_NOTES
FROM accMain

I want a character return between '---NOTE1---' and InterimNotes

Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com

 

[lupins46]

I assume by 'Character Return' you mean a new line:

SELECT '---NOTE1---' & Chr(13) & Chr(10) & InterimNotes & '---NOTE2---' & ACNotes as COMBINED_NOTES
FROM accMain

 

[ajaeger]

Thanks. That's it. What's the difference between Chr(10) & Chr(13)?

Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com

 

[TBONE917]

Chr(10) is the character represented by an ASCII value of 10 which is a line feed/ new line... Chr(13) is carriage return... the combination of these two works like a manual typewriter... carriage returns to its starting position all the way to the left then moves down a line