SELECT and Concatenating... 1

[Rjc8513]

I have [ID No] and [ID Name]. In a drop-down on a form, I want to display [ID No] & "- " & [ID Name].

The following works when I want to display the ID No alone in the drop-down but I cannot combine ID No and ID Name:

SELECT DISTINCT [UNIT LIST].[ID NO] FROM [UNIT LIST];

Is this possible?

Thanks.

Richard...

 

[jebry]

Hi!

You can try the following:

Select ([ID No] & "- " & [ID Name]) as NewField From [Unit List]

My code assumes that the Distinct command in your query above isn't needed because ID No sounds like it would already be unique. Hopefully ID No and ID Name together will be unique at least. You can substitute a name that makes sense in you query for the NewField above.

hth
Jeff Bridgham

 

[Rjc8513]

Thanks, Jeff. Worked like a charm!