[AccessD] Re: A2K and .Net

Robert L. Stewart rl_stewart at highstream.net
Wed Jul 6 13:10:42 CDT 2005


YourDate >= UnavailableFrom AND YourDate <= UnavailableTo

That should work the same as BETWEEN...AND



At 12:00 PM 7/6/2005, you wrote:
>Date: Wed, 6 Jul 2005 10:06:21 +0100
>From: "Griffiths, Richard" <R.Griffiths at bury.gov.uk>
>Subject: RE: [AccessD] A2K and .Net
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Message-ID: <200507060857.j668vJr19891 at smarthost.yourcomms.net>
>Content-Type: text/plain; charset="iso-8859-1"
>
>Ken
>thanks, as I thought. I accept that you would need to install all the VBA 
>dlls, but are you sure that you would need to instantiate an Access 
>session.  I'm sure most apps would use left, mid etc in queries and this 
>would mean say for all the many 1000's of VB apps that have an Access BE 
>they would need to install Access (runtime or full) and load an instance 
>each time a query was used.  Have you tried this?
>
>I have tried to use native JetSQL but for this query have struggled , 
>maybe someone can offer a solution.......
>
>
>I have two datetime fields UnavailableFrom and UnavailableTo (e.g. 
>01/01/2005 08:30 and 01/01/2005 18:30)
>
>Can anyone suggest any SQL (and also native JetSQL without function calls 
>[or with permitted function calls]) to find whether a date falls between 
>these two datetimes - so a parameter of say 01/01/2005 would return this 
>record.
>
>Thanks
>Richard





More information about the AccessD mailing list