Member Avatar for newbie_here

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????

  • 2 Contributors
  • 2 Replies
  • 73 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by newbie_here

Recommended Answers

All 2 Replies

Member Avatar for Teme64

Use DISTINCT keyword: SELECT DISTINCT Contractor FROM Companies

Member Avatar for newbie_here

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.