How to filter duplicate records

[Weebleman]

Hi,
I have a combo that I want to populate using an SQL SELECT query. The source table records have a Customer text field together with a LiveOrder checkbox field which is unchecked if the customer has a live order.
However, if a customer has more than one LiveOrder the customer's name appears duplicated for each open order in the combo list. How do I limit the combo to display the customer name just once rather than several times.
Thanks for any help.

 

[student]

One way would be to do a 'count' on the LiveOrder field in the query to give you number of live orders as well. It depends on exactly what you want the output to be?