Count total number of records in access database using condition

[aman1234]

Hi guys

I am using Access as a backend and Excel as a frontend. I want to count total number of records for todays where Time<13:01

Can anyone please modify the following code accordingly?

Please Login or Register  to view this content.

[nathansav]

if rs.Fields("Time")<"#13:01:00#" then Maybe??? Also, why not use SQL to give you the count?


"select count(ID) from table1 where Date = #" & Format(Now, "mm/dd/yyyy") & "# AND WHERE Time<='13:00'"


What are your data types? You seem to have date for the date, but is time a string value?