Hi...

I can't remember/find the query command to not show duplicates in a
RecordSet. I need to query a DB, but only show one record for each
address. I THOUGHT it was the "group by", but that is giving me an
error?

How can I write this so only one entry for each address shows up?

RS.Open "SELECT * FROM Members ORDER BY Address", Conn, 1,3

I want the list to only show one entry for each address, versus what
I'm getting now, which is multiple addresses for every member from
that particular address.

TIA...

Dian ~