View original (French)

ACCESS Query and Return Carriage

Rafy68 Posted messages 89 Status Membre -  
 onlyme -
Hello everyone,

In a query based on a text table, I want to combine two text fields into one.
The content of the second field should not appear after the first, but on a new line.
I can't find how to include a line break in my expression (expression generator).

Thank you in advance
Configuration: Windows XP Firefox 1.5.0.11

2 réponses

Réponse 1 / 2
invité
 
try Chr(13) & Chr(10) it should work
2
Réponse 2 / 2
blux Posted messages 2016 Registration date   Status Modérateur Last intervention   3 452
 
Hi,

there is a variable for this, it's called VbCrLf...
field1 & VbCrLf & field2
--
See you, Blux 
 "Those idiots will try anything. That's how you can recognize them"
0
Rafy68 Posted messages 89 Status Membre 29
 
It doesn't work, when executing the request a message box opens and asks me for the value of VbCrLf!!!
0
blux Posted messages 2016 Registration date   Status Modérateur Last intervention   3 452
 
Show us your SQL...

--
A+ Blux 
 "Fools dare everything. That's even how you recognize them"
0
Rafy68 Posted messages 89 Status Membre 29 > blux Posted messages 2016 Registration date   Status Modérateur Last intervention  
 
Here is what I was thinking of doing in my query and more specifically in the expression generator:

DESCRIPTION: [DESIGN1]+Car(13)+[LIB_UNITE]
0
blux Posted messages 2016 Registration date   Status Modérateur Last intervention   3 452 > blux Posted messages 2016 Registration date   Status Modérateur Last intervention  
 
I never use that expression generator thing, but you can try CHAR(13)+CHAR(10), which corresponds to carriage return + line feed...

--
A+ Blux 
 "Stupid people dare to do anything. That's how you recognize them"
0
ben4444
 
c bn &CAR(13)+CAR(10)&
0