pick out Unique Contacts from Multiple Lists

[niladri20052006]

Hi All,

I have a list consisting of 10000+ data where I have Company name,Title,
Email and website. There are multiple contacts for a single company.

I want to get only Network tiles unique contacts that means the list will be consisted of only Network titles for individual company.

What quires I will have to write?


Thanks in advance!

 

[Phildaburn]

In a query, select the fields you want to see in your results. In the properties of the query, find the "Unique Values" property and change it to Yes. Run the query. If you're more comfortable with SQL, just write a "Select Distict" query.

Phil...

 

[james_lankford]

try this for Access 2003
click Queries
clikc New
click Design View
al ist of tables come up
ignore tehem and just Click Close
click View
click SQL View
paste this

select 
 distinct
  [Company name],
  Title, 
  Email,
  website
from
  your_table
where 
  Title like '*network*'

change the name of your table and columns
run query