| | |
|
|
|
Access query |
|---|
| message from Judy on 7 May 2004 |
I want to join two or more text fields into one field.
When I run my query I'm only getting the first field and
not others. This is what I tried. Expr1:[des1]+[des2] and
I tried Expr1:[Des1]&[des2]
What am I doing wrong?
Thanks
|
| Steve Schapel replied to Judy on 08 May 2004 |
Judy,
Expr1: [Des1] & [des2]
... would appear to be the correct expression. Do you mean that when
you try this, the query only returns the data from the Des1 field in the
Expr1 column, and the data from the des2 field is not shown at all, in
any records?
|
| Judy replied to Steve Schapel on 7 May 2004 |
Yes, that is eactly what happens. I have more than 3
fields that I want to combine and I have tried it with 2 &
3 and then with 3 & 4. Each time I only get the first
field data no matter which field is first.
thanks, Judy
mean that when
Des1 field in the
shown at all, in
and
|
| Steve Schapel replied to Judy on 08 May 2004 |
Judy,
Just a shot in the dark here... Is it possible that there is a
"carriage return" at the end of the text in each field, so when you view
the results of the query the second field's data is still there, but on
a second line, so you wouldn't see it unless you expand the height of
the query row or form control?
|
|
Archived message: Access query (MS Access Error Message)
