Begin date
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 534030 articles for 2.100 sec
Thanks it works great! "Rick Brandt" <rickbrandt2@hotmail.com> wrote in message news:IUnUj.1951$7k7.624@flpi150.ffdc.sbc.com... > Kelvin wrote: >> I've used this string ">=[Begin Date] And <=[End Date]" many time, >> but I may not have used it on a field that has a default value of >> Now(). >> I have a field (in my table), DateOfSale with the following values. >> Format: Short Date >>     

Group: microsoft.public.access · Group Profile · Search for Begin date in microsoft.public.access
Author: Kelvin
Date: May 7, 2008 13:51

Thanks it works great! "Rick Brandt" <rickbrandt2@hotmail.com> wrote in message news:IUnUj.1951$7k7.624@flpi150.ffdc.sbc.com... Kelvin wrote: I've used this string ">=[Begin Date] And <=[End Date]" many time, but I may not have used it on a field that has a default value of Now(). I have a field (in my table), DateOfSale with the following values. Format: Short Date
Show full article (1.41Kb) · Show article thread
Thanks it works great! "Rick Brandt" <rickbrandt2@hotmail.com> wrote in message news:IUnUj.1951$7k7.624@flpi150.ffdc.sbc.com... > Kelvin wrote: >> I've used this string ">=[Begin Date] And <=[End Date]" many time, >> but I may not have used it on a field that has a default value of >> Now(). >> I have a field (in my table), DateOfSale with the following values. >> Format: Short Date >>     

Group: microsoft.public.access.queries · Group Profile · Search for Begin date in microsoft.public.access.queries
Author: Kelvin
Date: May 7, 2008 13:51

works great! Thanks "Beetle" <Beetle@discussions.microsoft.com> wrote in message news:F4082437-A7C5-45C3-89EB-65219D03D8E4@microsoft.com... Change your default value to Date() instead of Now() -- _________ Sean Bailey "Kelvin" wrote: I've used this string ">=[Begin Date] And <=[End Date]" many time, but I may not have used it on a field that has a
Show full article (1.41Kb) · Show article thread
works great! Thanks "Beetle" <Beetle@discussions.microsoft.com> wrote in message news:F4082437-A7C5-45C3-89EB-65219D03D8E4@microsoft.com... > Change your default value to Date() instead of Now() > -- > _________ > > Sean Bailey > > > "Kelvin" wrote: > >> I've used this string ">=[Begin Date] And <=[End Date]" many time, but I >> may >> not have used it on a field that has a     

Group: microsoft.public.access.forms · Group Profile · Search for Begin date in microsoft.public.access.forms
Author: Kelvin
Date: May 7, 2008 13:51

works great! Thanks "Beetle" <Beetle@discussions.microsoft.com> wrote in message news:F4082437-A7C5-45C3-89EB-65219D03D8E4@microsoft.com... Change your default value to Date() instead of Now() -- _________ Sean Bailey "Kelvin" wrote: I've used this string ">=[Begin Date] And <=[End Date]" many time, but I may not have used it on a field that has a
Show full article (1.41Kb) · Show article thread
Thanks "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message news:186AE3F2-2AC6-4FD7-AAED-9579A6E2A442@microsoft.com... > You can add a calculated field just for appling criteria like this -- > Criteria_Field: DateValue([DateField]) > Then apply criteria -- > >=[Begin Date] And <=[End Date] > OR > Between [Begin Date] And [End Date] > -- > KARL DEWEY >     

Group: microsoft.public.access · Group Profile · Search for Begin date in microsoft.public.access
Author: Kelvin
Date: May 7, 2008 13:51

Thanks "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message news:186AE3F2-2AC6-4FD7-AAED-9579A6E2A442@microsoft.com... You can add a calculated field just for appling criteria like this -- Criteria_Field: DateValue([DateField]) Then apply criteria -- =[Begin Date] And <=[End Date] OR Between [Begin Date] And [End Date] -- KARL DEWEY
Show full article (1.11Kb) · Show article thread
Thanks "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message news:186AE3F2-2AC6-4FD7-AAED-9579A6E2A442@microsoft.com... > You can add a calculated field just for appling criteria like this -- > Criteria_Field: DateValue([DateField]) > Then apply criteria -- > >=[Begin Date] And <=[End Date] > OR > Between [Begin Date] And [End Date] > -- > KARL DEWEY >     

Group: microsoft.public.access.queries · Group Profile · Search for Begin date in microsoft.public.access.queries
Author: Kelvin
Date: May 7, 2008 13:51

Thanks Fred! Thanks for the explination! I changed it to Date() and it works great! Thanks for your time! "fredg" <fgutkind@example.invalid> wrote in message news:10qze20zesev4.1s5nrcgph6vkh.dlg@40tude.net... On Wed, 7 May 2008 14:54:46 -0500, Kelvin wrote: I've used this string ">=[Begin Date] And <=[End Date]" many time, but I may not have used it on a field that has
Show full article (1.11Kb) · Show article thread
    

Group: microsoft.public.access.forms · Group Profile · Search for Begin date in microsoft.public.access.forms
Author: Kelvin
Date: May 7, 2008 13:51

Show full article (1.11Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Begin date in microsoft.public.access
Author: Kelvin
Date: May 7, 2008 13:50

Show full article (1.30Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Begin date in microsoft.public.access.queries
Author: Kelvin
Date: May 7, 2008 13:50

Show full article (1.30Kb) · Show article thread
    

Group: microsoft.public.access.forms · Group Profile · Search for Begin date in microsoft.public.access.forms
Author: Kelvin
Date: May 7, 2008 13:50

Show full article (1.30Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Begin date in microsoft.public.access
Author: Kelvin
Date: May 7, 2008 13:50

Show full article (2.19Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next