Forums
This topic is locked
SELECT * FORM string don't show same cells
Posted 21 Sep 2005 21:39:28
1
has voted
21 Sep 2005 21:39:28 Matthijs de Groot posted:
Hope I can explain my problem clearly...I have a recordset connection
[code]
rs_record.Source = "SELECT * FROM table1 WHERE id = " + Replace(rs_record__MMColParam, "'", "''"
+ ""[/cod]
Works fine, but...
The table has a few records with the same data in it. Now I want to make the selection eliminate ore hide the records that are the same as an early record with the same data.
Replies
Replied 22 Sep 2005 18:30:20
22 Sep 2005 18:30:20 Michael Behan replied:
try this:
rs_record.Source = "SELECT DISTINCT * FROM table1 WHERE id = " + Replace(rs_record__MMColParam, "'", "''" + ""
rs_record.Source = "SELECT DISTINCT * FROM table1 WHERE id = " + Replace(rs_record__MMColParam, "'", "''"
+ ""