Access - Query - Carriage return

[sellert]

I have a query that combines remarks from different tables for a report. I want it to do a carriage return for each type of remark. Is there a way to do this in the query, or is it only possible in the report? I have tried chr(13) and vbcrlf, with no success.

Thanks,
SELLERT

If I'm not learning I must be coasting. If I am coasting I must be going down hill.

 

[Remou]

You need carriage return, line feed:

[tt] (Chr(13)+Chr(10))[/tt]

 

[Crowley16]

vbcrlf is both 10 and 13...

try putting in 2 vbcrlfs

--------------------
Procrastinate Now!

 

[Remou]

Crowley16
In my version of Access (2000), it is not possible to use vbCrLf in queries.

 

[Crowley16]

it must be available from 02 onwards then...

--------------------
Procrastinate Now!

 

[TheAceMan1]

How are ya sellert . . .

Have you tried:

[blue]Remark1 & [purple][b]Chr(13) & Chr(10)[/b][/purple] & Remark2[/blue]

See Ya! . . . . . .

 

[Remou]

TheAceMan1

Perhaps you did not see my post dated 26 Mar 07 18:27 ?

 

[JoeAtWork]

Crowley16

vbCrLf is a VB constant, and thus not available in a query.

If I make a query like the following in Access2003

SELECT Code, Desc, [Code] & vbCrLf & [Desc] AS CodeDesc
FROM Codes

I will be prompted to enter the "vbCrLf" value.

 

[sellert]

This would be access 97, it won't allow vbcrlf, or ASCII codes.

Thanks,
SELLERT

If I'm not learning I must be coasting. If I am coasting I must be going down hill.

 

[TheAceMan1]

sellert . . .

Post the quetry! . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[TheAceMan1]

Woops! . . . post the query!

See Ya! . . . . . .

Be sure to see FAQ219-2884: