Hi ?,
You are not doing anything wrong on the face of it.
Just make sure that [DateClosed] is a Date field.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "WonderBoyMI" <wonderboymi@...> wrote:
>
> 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?
>
__._,_.___
.
__,_._,___
Tidak ada komentar:
Posting Komentar