Hello,



I am currently running a query on Excel that gathers data from an Access database. The data consists of updated information that gets inputted every ten minutes. The query has a criteria that is supposed to pick up data from midnight of the current date. The value I am using is Date()

This query was working properly a few days ago, but ever since 2/2/09, I get an error stating that the "Number value out of range (null)" error. For some reason, when I change the datetime value to outside of the 12:00am to 12:20am range, it picks up with no problems at all. It seems to have something to do with the time value within that range that is causing the error. Is anybody familiar with this particular dilemma? Any help would be great.