Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Problem with SELECT DISTINCT...plz help.

Author  Topic 

BigSom
Starting Member

1 Post

Posted - 2000-11-15 : 11:39:51
Hi,

I have 229 records in my Access DB.
> SELECT DISTINCT ipAddress FROM townHallSurvey;
returns 225 records, therefore there are 4 duplicate ipAddress fields right??

But, when I have this statement:
> SELECT Q2, Count(*)
> FROM townHallSurvey
> WHERE ipAddress in
> (SELECT DISTINCT ipAddress FROM townHallSurvey)
> GROUP BY Q2;

it counts all 229 records rather than 225. Am I missing something??

Thanks.
   

- Advertisement -