Including a 'non field' word in a string Concatenation

[Guest]

I have 4 field boxes that I want to join, but with a non-Field word (to)
appearing in the middle of the sentence.

Like this:

Main St, E1 To South St, N1

My Fields are:

[Run_From] & [Run_From_Postcode] & "To" & [Run_To] & [Run_To_Postcode]

 

[missinglinq via AccessMonster.com]

Sorry, but what's your question? The only thing I see wrong with what you
have is that you need a space on either side of "TO" and some commas, i.e.

[Run_From] & ", " & [Run_From_Postcode] & " To " & [Run_To] & ", " &
[Run_To_Postcode]

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

Hello Monster,

my question, albeit badly worded, was why isn't this syntax working, I got
just the first half of the route. But since discovered that I had to close
and re-open the form for it to change to what i wanted. problem solved now.
thanks for the feedback on the spaces and commas.