"Merge" to text fields in query.

[selvsagt]

Hi,

I am trying to "merge" to textfields in a query.
One field is [domene], the other has the name [VLini].

I need these fields to end up like this: DOMAIN/VLINI
I am trying to make a security check with AUTH_USER from the domain user, but it also requires the domain name. Since there are users from multiple domains I need to merge these two in to one field called username.

I have tried:

username: [domene]"/"[VLini] but this only produces a "-1" answer.

Anyone?

 

[MStef]

try this.
username: [domene] & "/" & [VLini]

 

[selvsagt]

Thanks, it almost works...
I get:

DOMENEVVLINI

It adds a "v" instead of a "/" ???

 

[selvsagt]

Forget it... my bad..I had already added the "/" in the domene field.


Thanx a bunch! You rock!