On my shipping invoices, which are reports,  I'm trying to display a line
that shows the following line: From Origin to Destination (Origin and
Destination being fields in the source query)
As the length of the Origin town varies I don't want to use fixed fields for
each value as this would either leave ugly gaps or the data would overwrite
each other.
So I have tried to concatenate everything in one textbox, with the word "to"
sandwiched in the middle. This is what I have tried:
=[Origin] & " " & to & " " & [Destination]
(I also tried it with extra quotes around "to" but then it printed it
exactly like that, showing the quotes).
Depending on what I do with the the position of the spaces and the
ampersands, I either get an incorrect syntax message or Access thinks that
the word to is a parameter and throws square brackets around it and asks me
for input when I run the report.
Where am I going wrong?
Many thanks
CW