join two fields in a question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Victor - 28 Sep 2006 22:09 GMT

i know how to combine two fields in a question to get for example name and
surname together, but i can't get a spacing between the name and surname ex.

this is the way i want it...
olle andersson

this is the way i get it:
olleandersson ...... Uttryck1: [name]+[surname]

Reply to this Message

Duane Hookom - 28 Sep 2006 22:49 GMT

Use the ampersand to concatenate text/string values:
Uttryck1: [name] & " " & [surname]

Signature

Duane Hookom
MS Access MVP

>i know how to combine two fields in a question to get for example name and
> surname together, but i can't get a spacing between the name and surname
[quoted text clipped - 5 lines]
> this is the way i get it:
> olleandersson ...... Uttryck1: [name]+[surname]

Reply to this Message