Grouping Names to diaplsy them only once?

[AWilderbeast]

Hi I have a list of company names in a form which gets its records from a query some of the companys have more than one entry, is there an way i can group the entrys so it only displays them once?


(removing duplicates is not an option as the query is made up from 2 tables and it is needed to make another part work)

Thanks for any assistance

 

[AWilderbeast]

Figured it out

Dosent matter i figured out myslef if anyone else comes across this problem use a different query to display a list of businesses and using your vbscript for opening a record open the form with your details in the name will still be displayed fine