[ms_access] Query Request - DISTINCT equalivant

[Ed Patterson]

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;