Unique Values in query!

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
That should return one row for each different value of Cb7.

Is that not what you're observing?
 
Douglas the Combo Box Control Source is: CB7
and Row Source is: SELECT qryCb7List.Cb7 FROM qryCb7List;
Thanks....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
 
Back
Top