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 "[email protected]"
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)
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 "[email protected]"
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)