Dcount still returns a value

[mahmed1]

Hi Lovely people

I am trying to look at a table field in access to see if todays date exists in a column, if it does then dont run else continue however even thoigh the date doesnt exist - it still returns it as found - Please tell me whats wront with this code?

If DCount("Date_Ran", "tbl_Log", Int(Now)) > 0 Then
MsgBox "DB Has Already Been Updated"
Exit Sub
End If

 

[JonXL]

DCount("*", "tbl_Log", "Date_Ran = #" & Date() & "#")

 

[xenou]

Probably also:

If DCount("Date_Ran", "tbl_Log", "DateRan > Int(Now)") > 0 Then

The main thing is that the third argument must be a WHERE clause without the WHERE keyword, not just an integer.

 

[mahmed1]

Thank you so much all