View Single Post
  #5 (permalink)  
Old October 17th, 2003, 03:04 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default


Jeff, This will work

SELECT (SELECT COUNT(*) FROM yourtable T2 WHERE T1.Today=T2.Today AND T2.EntryDate<=T1.EntryDate) AS TheeCount, T1.EntryDate, T1.Today
FROM yourtable AS T1
WHERE ((((SELECT COUNT(*) FROM yourtable T2 WHERE T1.Today=T2.Today AND T2.EntryDate<=T1.EntryDate))<>0));


I checked it on my PC. Here is what you do.

Make sure that there are two date fields
Today (is a date field that only keeps the current date IE 10/17/2003
          Dafault Value is Date()
EntriTime (date field formated to keep date and time)
         Default Value is Now()











Sal
Reply With Quote