Join strings in Query

M

matty ratafairy

I have a "Customer" form to input customer details. The e-mail address is in
two parts: "e-name" and "Provider". I have a Provider table the field in my
table shows IDProvider"1" Provider"hotmail.com" and "2" "yahoo.es" etc. This
is related to IDCustomer in a 1 to many relationship.

I want to join them so, I made a "Full e-mail" query expr1:
[e-name]&"@"&[Provider]

This returns "matty@1" when I'm expecting "(e-mail address removed)"

If I do simple query to return Col1 e-name and col2 Provider it gives col1
"Matty" and col2 "hotmail.com"

What am I missing? (Except a brain)
 
M

matty ratafairy

Its ok I found a way - I removed the Primary key field and made the
"Supplier" the primary key.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top