Setting up a Carriage Return (Access 2000)

[APATTO03]

I'm trying to set up an expression (in the query builder) to concatenate two fields together, and between the two fields, specify carriage return. I'm having a hard time setting this up. Does anyone know how I can specify a carriage return in the expression builder?
(similar to the ALT+ENTER character in excel).
Thanks,
Drew

[HansV]

Use something like

=[Field1] & Chr(13) & Chr(10) & [Field2]

Chr(13) is a carriage return, and Chr(10) is a line feed. The & character concatenates strings.

[APATTO03]

Thank you very much!
Works great!