Select Distict Results from a query

J

James

Thanks to people Here I've have a query that trims websites down:

SELECT
Mid([WebProxyLog1.uri],8,InStr(Right([WebProxyLog1.uri],Len([WebProxyLog1.ur
i])-7),"/")-1) AS URI
FROM WebProxyLog1;

Now I want to get distinct results only. So I made another query based on
the first one, that is set to select the distinct results from the previous
query :

SELECT DISTINCT [WebProxyLog Query].URI
FROM [WebProxyLog Query];


This doesn't work though, What Am I doing wrong?

THanks
 
J

James

Gives me an error message

Ken Snell said:
"Doesn't work"... meaning, you get no records? You get more than one record?

--

Ken Snell
<MS ACCESS MVP>

James said:
Thanks to people Here I've have a query that trims websites down:

SELECT
Click to expand...
Mid([WebProxyLog1.uri],8,InStr(Right([WebProxyLog1.uri],Len([WebProxyLog1.ur
i])-7),"/")-1) AS URI
FROM WebProxyLog1;

Now I want to get distinct results only. So I made another query based on
the first one, that is set to select the distinct results from the previous
query :

SELECT DISTINCT [WebProxyLog Query].URI
FROM [WebProxyLog Query];


This doesn't work though, What Am I doing wrong?

THanks
Click to expand...
Click to expand...
 
J

James

Got it working
thanks
James said:
Gives me an error message

Ken Snell said:
"Doesn't work"... meaning, you get no records? You get more than one record?
Click to expand...
Mid([WebProxyLog1.uri],8,InStr(Right([WebProxyLog1.uri],Len([WebProxyLog1.ur
i])-7),"/")-1) AS URI
FROM WebProxyLog1;

Now I want to get distinct results only. So I made another query
Click to expand...
Click to expand...
based
on
the first one, that is set to select the distinct results from the previous
query :

SELECT DISTINCT [WebProxyLog Query].URI
FROM [WebProxyLog Query];


This doesn't work though, What Am I doing wrong?

THanks
Click to expand...
Click to expand...
Click to expand...
 
Top