creating a combo box that holds the value of 2 fields

[dj662003]

In my consumer information table there are 3 fields for each individual consumers name, I.E. - "Field 1 = first name,Field 2= middle name, Field 3= last name.
I want my combo box to hold all of my customers first and last names. I appreciate any help that is offered

 

[TheAceMan1]

How are ya dj662003 . . . . .

Have a look into [blue]Union Queries[/blue] . . . . .

See Ya! . . . . . .

 

[willir]

DJ

Are you looking for...
[tt]
Select FirstName & " " & Nz(MiddleName, "") & " " & LastName AS CustomerContact From ....
[/tt]

I used Nz(MiddleName, "") in case you have names without middle names.

Richard

 

[TheAceMan1]

dj662003 . . . . .

I did'nt read you post correctly. You do not need Union Query. In fact, [blue]willir[/blue] is right on target.

Haaaaay willir! I think I got [blue]Post Hypnosis[/blue] on this one!

See Ya! . . . . . .

 

[willir]

AceMan With all your bubbly cheer, there is no need to appologize. This is an easy one -- I got one of "those ones" at
Driving me nuts

Oh well.

 

[dj662003]

Thank you both for the response but, I am not familiar with code. is there any chance that you could translate that for me?

 

[TheAceMan1]

dj662003 . . . . .

Have you ever made a query?

This helps to determine what to explain . . .

See Ya! . . . . . .