Question:
I keep getting a syntax error on the last part of this statement:
"SELECT DISTINCT [Company Name], [Street Address] FROM " & d & " WHERE[Street Address] !="
Maybe I am using the wrong syntax, but how do I also get distinct addresses when this database has duplicate names and addresses, and some with duplicate names and different addresses?
Answer:
The syntax error in this SQL statement is most likely the missing “!=” condition. You must specify what the [Street Address] column is not equal to. If I understand your situation, you could have duplicate address and duplicate names so you could create a subquery that first gets distinct addresses and then gets distinct names from that subset of records like this:
SELECT DISTINCT [Company Name] FROM TEST WHERE [Street Address] IN (SELECT DISTINCT [Street Address] FROM TEST)