Unique Values in query!

[Bob]

How can I adjust this script in my query so as I have unique values in my
list:

SELECT DISTINCT qryCb7.Cb7
FROM qryCb7
WHERE (((qryCb7.Cb7) Is Not Null));

This is a query of a query.........Thanks bob








..........Jenny Vance

 

[Douglas J. Steele]

That should return one row for each different value of Cb7.

Is that not what you're observing?

 

[Bob]

Douglas the Combo Box Control Source is: CB7
and Row Source is: SELECT qryCb7List.Cb7 FROM qryCb7List;
Thanks....Bob

 

[Bob]

Oh Ok, I got it now I has a Query from a Query, it should have been a Query
from the table, Got it going now Thanks......Bob