Unique records to populate combobox 1

[IknowMe]

Ok, Skip got me going on the query a query now I need some more help.

Say my Query returns such

Name Phone Address

What I need to do is populate a combobox with all unique phone numbers in my query. I am using the selection to build another query to provide a report. I currently am able to get it to populate with all the phone numbers in the query but if two records use the same number I get duplicate choices in my combobox.

Please tell me there's a simple way to filter to unique records only in my combobox.

Wow, I'm having amnesia and deja vu at the same time.
I think I've forgotten this before.

 

[PHV]

Have a look at the DISTINCT predicate in the JetSQL help:
SELECT DISTINCT Phone FROM yourQuery

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[IknowMe]

Awesome as usual.

Wow, I'm having amnesia and deja vu at the same time.
I think I've forgotten this before.