Look-up 3 filds through 1 Combo

  • Thread starter Thread starter Kahuna
  • Start date Start date
K

Kahuna

Hi Folks

I have a table with 3 fields holding email addresses (need to be separate
for other reasons) and I'd like to show them all through 1 combo box.

Any thoughts on how to query three fields into the one list?

Cheers
 
Concatenate the 3 fields together. This example assumes that you have
the email address broken into user, domain, and type

Select ClientID
, [Email1] & "@" & [Email2] & "." & [Email3] as Email
FROM yourTable

Then set the column count of your combo to 2, set the bound column to
1, and set the colum width property to: 0;2.5

--
HTH

Dale Fye


Hi Folks

I have a table with 3 fields holding email addresses (need to be
separate
for other reasons) and I'd like to show them all through 1 combo box.

Any thoughts on how to query three fields into the one list?

Cheers
 
Try this... Field1 & " - " & Field2 & " - " & Field3 ... The dashes don't
need to be included, just 1 ampersand... there are other ways of splitting
the data up when its in only 1 field that may help...

HTH.

Tom.
 
Cheers Tom - that works too. Funny how one cant quite get a handle on the
simpler things!
 
Oops that's not it at all Dale

I have 3 full email addresses in three fields and I need to list them all in
one combo, so:

Email1 Email2 Email3
(e-mail address removed) (e-mail address removed) (e-mail address removed)

I'd like to show them all in once combo as if they all resided in the same
table / field.

Any further ideas?

Cheers
 
Tom - I misunderstood your reply first time around, as I did with Dale.

I have 3 full email addresses in three fields and I need to list them all in
one combo, so:

Email1 Email2 Email3
(e-mail address removed) (e-mail address removed) (e-mail address removed)

I'd like to show them all in once combo as if they all resided in the same
table / field.

Any further ideas?

Cheers
 
You can use a UNION query... Something like...

SELECT tblEmal1.Email1 FROM tblEmail1 UNION SELECT tblEmal1.Email2 FROM
tblEmail1 UNION Select tblEmal1.Email3 FROM tblEmail1;

HTH.

Tom.
 
Back
Top