Trouble with Group by

[techgnome]

This is what I did

"Select affiche, Count(num)as num from Table1 where num = " & Text1.Text & " GROUP BY affiche", DB, adOpenStatic, adLockOptimistic
Do Until RSS.EOF
     Debug.print RSS(0) 
    RSS.MoveNext
Loop

Nothing happens

Well that's a blatant lie... something did happen... something should have been written out to the debug window. Did you look? What do you want? Big giant flashing neon signs? Did you even try setting a break point, stepping through the code and seeing the values one by one? Maybe it's the lack of coffee talking but this feels like dealing with my 9 year-old ... if it doesn't come right out, slap her in the face, she throws her hands up and says "it's toooo harrrrd" and gives up.

What about the table? Did you try looking in the table? That's where the data is... What's in the table? That doesn't take any special skills. What about running the query through Query Designer first? hhhmmmm?


It's moments like this that make me wonder what the hell they are teaching these days... clearly debugging and diagnostics is not on any of the agendas out there...



-tg