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
