Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2003
    Location
    uk
    Posts
    47

    Unanswered: Help with a query

    I have a query that has a an id and an entry;
    [vb]
    id | entry1 | entry2 | entry3
    -----------------------------------------------
    20 | 1 | 2 | 3

    [/vb]


    I need to either create an update query, append or make table query so that it displays:

    [vb]
    id | Entry |
    -------------------
    20 |123 |

    [/vb]
    i have got it to work using [vb]expr1:entry1 &" " & entry2[/vb]
    the problem is that it exceeds the limit of 255 characters in the field, so i need it to either insert into another table where it has a memeo field, so that i can display all the information.
    I have been trieng this for ages and i am going mad as i cannot get it to work.
    Please someone help ! Cheers dave

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    May I ask why you need to do this? There may be ways other then the query depending on what you need it for.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Nov 2003
    Location
    uk
    Posts
    47
    I have a datareport in vb that needs all the entries from a certain id in one text box so that it can be displayed.... so i need to group all the enries of that certain id into one .. otherwise there would be hundreds of records

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    That's the answer I was hoping for...

    Perform the concatenation at the report level instead.

    =[field1]+[field2]+[field3] etc

  5. #5
    Join Date
    Nov 2003
    Location
    uk
    Posts
    47
    is this possible through the datareport in vb??

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Oh, you mean as in "Not MS Access"? I wouldn't know, this is the MS Access forum. My limited experience with datareports in VB left me so furious i'll never look at that platform again.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Nov 2003
    Location
    uk
    Posts
    47
    i am trinbg to concatenate through access then load it into vb.. thanks Any way mate

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •