are you creating the query in the query designer? if yes, then you can right click the query area, choose properties and set Unique Values = yes
--- In [email protected], "Ed Patterson" <[EMAIL PROTECTED]> wrote: > > With SQL Server I can use the query below to get a list of unique ranges. > > SELECT DISTINCT > LEFT(IPAddress, LEN(IPAddress) - CHARINDEX('.',REVERSE(IPAddress))) > Exp001 FROM Addresses > > In Access the closest I have been able to come to to strip the hosts > octet off. Whilst DISTINCT shows in the online help, I get a syntax > error every time I try to use it. > > Access version so far, needs the DISTINCT portion to be complete > > SELECT left(ipaddress,len(ipaddress)-instrrec(ipaddress,".") > Exp001 FROM Drips; >
