VilaRestal
';drop database master;--
- Local time
- Today, 08:04
- Joined
- Jun 8, 2011
- Messages
- 1,042
Just put DISTINCT after SELECT:
strSQL = "SELECT DISTINCT [Full Unitname] FROM CS WHERE "
strSQL = "SELECT DISTINCT [Full Unitname] FROM CS WHERE "
Filter query that may contain null values
- Thread starter johandenver
- Start date
johandenver
Registered User.
- Local time
- Today, 09:04
- Joined
- May 4, 2010
- Messages
- 27
Brilliant!
