Okay I did this. How do I display the count? .Open "SELECT count(*), SentDate FROM Requests group by SentDate", cn, adOpenDynamic, adLockOptimistic .MoveFirst Do While Not .EOF MsgBox rs.Fields("SentDate") MsgBox rs.Count '??? Loop
Tips, Examples & Tutorials: A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners 2009 - 2016
Forum Rules
2009 - 2016
Reply With Quote