Querying Between Dates

[WayneRyan]

Hi all,

I just went into Rose's table and changed the date in the
table to "12/16/2003 11:00:00 AM" and it no longer returns
that record in the query.

If you use Short Dates to query against Date/Time data, you
will have to add a day to the ending date in the criteria.

Wayne

 

[Jim W]

Wayne it now does make sense.

Thanks
Jim

 

[WayneRyan]

Jim & Rose,

Thanks for going thru this. Rose's sample helped immeasurably.

See you next time.

Wayne