Rabu, 03 Agustus 2011

[MS_AccessPros] Strange date problem

 

Good morning everyone;

I'm having an issue which has me banging my head against my desk (I'm sure we all do this regularly!)

Anyway, I have a query with only two fields. [ScheduleId] and [DateClosed]

My manager wants me to make him a report showing all of the IDs from yesterday, but when I put #8/2/2011# in criteria I get no results. However, there are IDs from yesterday, and if I do a range that includes yesterdays date I get them.

What am I doing wrong?

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar