Hi all i am new to Access

Some info about my project.. I am designing a system for my company.. my compnay has many contractors. so i have a field in my database called contractors. In a point i need to retrieve how many different kinds of contractors are there from my database . So there should not be any repetition. is there any way i can achieve this in a select statement????

Use DISTINCT keyword: SELECT DISTINCT Contractor FROM Companies

Thanks a lot it worked for me... Thanks a lot

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.