Combine fields Text to Memo

B

Buddy

I am combining 8 text fields into one memo field using a query. After each
field I want a line feed so that each text field will be on a separate line
in the memo, but I don't know the syntax. Any help will be appreciated.
the query line looks like:
x:F001 & F002 & F003 etc.

Thanks
 
S

stumac

Chr(13) & Chr(10)&[F001]& Chr(13) & Chr(10)&[F002]&Chr(13) & Chr(10)&[F003]

this will put them each on to a new line.

Stu
 
Top