[Resolved] Access Queries

[kows]

I am mostly familiar with MySQL and consider myself well versed in it, but am using Access to create a program for a company. It's fine and all, the queries using ADO in VB are very similiar if not exactly the same. However, I've run into a sort of problem. I want to list all of the different companies I have by just using one query, but I only want ONE result per company, because I just want to have that company's name so that it can be used to get a "general information" when clicked. I'm not sure if this is even possible. I can do it programmatically but I just want to limit the amount of overhead I've got, so structuring and limiting the results I get without having to sort through them using code would be a big help.

[Dnereb]

Use
SELECT DISTINCT CompagnyName, ...., ...., ... FROM YourTable