Date (1 Viewer)

[Tkandy]

I need to put a contol on a Db that makes sure there is a entry for every day.

I have [date] and [well reading] in the table.

 

[Steve R.]

I assume you mean that data is entered every day, meaning 365 entries during the course of the year. If that is the case, sort the table/query by date declining. Use NOW() with the most recent date recorded with DATEDIFF function. If you get a number equal to or larger than 1, then you are missing dates.

 

[John Big Booty]

I would suggest that you use the Date() function in preference to Now().

Date() will return the current date whilst Now() returns the current date along with the current time. So unless you specifically need a time component steer clear of Now() as the time component complicates the process of comparing dates.