You can use "Some text" & vbCrLf & "Some more text". This will cause "Some more text" to appear in a new line. This should work for both Memo and Text data types.

This is an old thread but here you go anyways…

Say you have a Table named 1A and Three Fields Named COUNTRY, COMPANY and BALANCE.
The following SQL Code Counts Each Company in each Country and...