"Concatenated" fields in combo?

[Guest]

In Row Source of combo we have:

SELECT DISTINCT [T_CadQuad].[IdSector], [T_CadQuad].[Quad] FROM T_CadQuad
WHERE ((([T_CadQuad].[Quad]) Is Not Null)) ORDER BY [T_CadQuad].[IdSector],
[T_CadQuad].[Quad];

Column Count=2
Bound Column = 2

And work fine, but I would like to pu the question:

Is possible to show permanently both (IdSector+Quad) fields in "window"
combo after click, please.

Thanks in advance.
an

 

[Guest]

try...
SELECT DISTINCT [T_CadQuad].[IdSector] & " : " & [T_CadQuad].[Quad] as
DisplayText , [T_CadQuad].[Quad] FROM T_CadQuad
WHERE ((([T_CadQuad].[Quad]) Is Not Null)) ORDER BY [T_CadQuad].[IdSector],
[T_CadQuad].[Quad];

 

[George Nicholson]

SELECT DISTINCT [T_CadQuad].[IdSector], [T_CadQuad].[Quad],
[T_CadQuad].[IdSector] & " " & [T_CadQuad].[Quad] As Combined FROM T_CadQuad
WHERE ((([T_CadQuad].[Quad]) Is Not Null)) ORDER BY [T_CadQuad].[IdSector],
[T_CadQuad].[Quad];

Column Count=3
Bound Column = 2
Column Widths 0;0;1

 

[Guest]

JackP,

Thanks for your solution.
Work Fine.
(There are a smal conflict with ORDER BY, but if to omit it, result fine.)
an

 

[Guest]

George Nicholson

Work impeccably!
Don't return any error.

Many, many thanks for you help.
an

SELECT DISTINCT [T_CadQuad].[IdSector], [T_CadQuad].[Quad],
[T_CadQuad].[IdSector] & " " & [T_CadQuad].[Quad] As Combined FROM T_CadQuad
WHERE ((([T_CadQuad].[Quad]) Is Not Null)) ORDER BY [T_CadQuad].[IdSector],
[T_CadQuad].[Quad];

Column Count=3
Bound Column = 2
Column Widths 0;0;1

--
George Nicholson

Remove 'Junk' from return address.

In Row Source of combo we have:

SELECT DISTINCT [T_CadQuad].[IdSector], [T_CadQuad].[Quad] FROM T_CadQuad
WHERE ((([T_CadQuad].[Quad]) Is Not Null)) ORDER BY
[T_CadQuad].[IdSector],
[T_CadQuad].[Quad];

Column Count=2
Bound Column = 2

And work fine, but I would like to pu the question:

Is possible to show permanently both (IdSector+Quad) fields in "window"
combo after click, please.

Thanks in advance.
an