Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Concatenation Fault (Access 97)

    Hi folks, wonder if anyone can help with this. I am concatenating a string which involves joining text fields and date fields with other textual values. See below:

    Links: (("http://www.travelout.com/travel.asp?OutDepAir=") & [Depart] & "&RetDepAir=" & [Arrive] & "&OutBusDate=" & [Date] & "&LastBooking=" & [LastBooking] & "&Price=" & [Price])

    My problem is that I need to have no spaces between any of these items, but although this works fine for the date fields, the text values [Depart] and [Arrive] both have spaces after them which I'm told will cause problems when trying to upload to the web. Both fields have a length of 3 in the table design, and the text length will always be 3. I am then transferring the file as an Excel97 spreadsheet (.csv) and at the moment am manually taking out 2 spaces between these fields and the rest of the text. Can anyone help???

    Many thanks. Marion

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Concatenation Fault (Access 97)

    Does it help if you use Trim([Depart]) and Trim([Arrive]) instead of [Depart] and [Arrive] ?

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenation Fault (Access 97)

    Aha! Indeed it does - thanks, again Hans X

Posting Permissions

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