Mark A Matte
markamatte at hotmail.com
Wed Aug 29 13:09:52 CDT 2007
Not entirely...if the field is just a date and not a datetime...then BETWEEN 1/1/07 and 1/1/07 would return any records that are 1/1/07 because BETWEEN is inclusive. If it were a datetime...then it would only look for 1/1/07 00:00:00. Mark A. Matte >From: "Susan Harkins" <ssharkins at gmail.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "'Access Developers discussion and problem >solving'"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] Date-scoping >Date: Wed, 29 Aug 2007 12:39:44 -0400 > >Oh, nicely done! I didn't even compare the dates -- just checked the >syntax! > >Susan H. > >I don't use BETWEEN much but technically there's no date between your 2 >values when they're the same. Does it work with =? > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Learn.Laugh.Share. Reallivemoms is right place! http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us