View original (French)

ACCESS Query and Return Carriage

Rafy68 Posted messages 89 Status Member -  
 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 answers

  1. invité
     
    try Chr(13) & Chr(10) it should work
    2
  2. blux Posted messages 2051 Registration date   Status Moderator Last intervention   3 455
     
    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
    1. Rafy68 Posted messages 89 Status Member 29
       
      It doesn't work, when executing the request a message box opens and asks me for the value of VbCrLf!!!
      0
    2. blux Posted messages 2051 Registration date   Status Moderator Last intervention   3 455
       
      Show us your SQL...

      --
      A+ Blux 
       "Fools dare everything. That's even how you recognize them"
      0
    3. Rafy68 Posted messages 89 Status Member 29 > blux Posted messages 2051 Registration date   Status Moderator 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
    4. blux Posted messages 2051 Registration date   Status Moderator Last intervention   3 455 > blux Posted messages 2051 Registration date   Status Moderator 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
    5. ben4444
       
      c bn &CAR(13)+CAR(10)&
      0