Assume we have these:
a,b,a,c,d,d

How many different letters are there?

Here's a simple zipped access file which includes a table of these letters, please make a simple query for that question.:o

??

Please review the guidelines on asking for help with homework that can be found here:

Ask Me Help Desk - Announcements in Forum : Arts & Literature

We won't do your work for you, but I will give you a hint:

SELECT DISTINCT

Quote:

---

Originally Posted by ScottGem

Please review the guidelines on asking for help with homework that can be found here:

Ask Me Help Desk - Announcements in Forum : Arts & Literature

We won't do your work for you, but I will give you a hint:

SELECT DISTINCT

---

I spent the whole day trying Distinct at SQL view and searching at access help and web... just give me the stright answer, I'm not studying DB, it's just one course for business major..
Any way accourding to some websites there is no Distinct Count in Access 2003... just give me a simple way to do it:eek:

Again, we will NOT do your work for you. I tend to doubt that you spent some much time trying to find this solution because the answer is very simple. If you want to show me what you tried and may be able to help further.

Quote:

---

Originally Posted by ScottGem

Again, we will NOT do your work for you. I tend to doubt that you spent some much time trying to find this solution because the answer is very simple. If you want to show me what you tried and may be able to help further.

---

Believe me I even borrowed a book from library

Code:

---

SELECT Count(letters) AS CountOfletters
FROM [SELECT DISTINCT letters FROM New; ]. AS T;

---

It has less than 5% of the total marks... IT in Business course

You are trying to hard.

SELECT DISTINCT letters FROM New;

Then look at the count.

I have never been so confused, I feel like I am in a foreign language thread.