Groups > comp.databases.ms-access > #14379

Re: Need some SQL

From	Neil <neil@myplaceofwork.com>
Newsgroups	comp.databases.ms-access
Subject	Re: Need some SQL
Date	2021-08-16 21:54 -0400
Organization	A noiseless patient Spider
Message-ID	<sff4t2$ssd$1@dont-email.me> (permalink)
References	(11 earlier) <0d6fc0ec-3dba-40e2-bf16-66dddb98566dn@googlegroups.com> <sfect4$458$1@dont-email.me> <sfef9r$kg6$1@dont-email.me> <9ca91ce3-8cdf-4762-8686-cc591c1da0f9n@googlegroups.com> <sfeus9$rij$1@dont-email.me>

Show all headers | View raw

On 8/16/2021 8:11 PM, Neil wrote:
> On 8/16/2021 5:51 PM, Keith Tizzard wrote:
>> The condition needs to work for any StartDate and EndDate.  An earlier 
>> suggestion worked when they were both in the same year but not in 
>> different years.
>>
>> I just gave one possible example of 7 Nov and 14 January where your 
>> condition works.  However is does not work when the dates are in the 
>> same year.
>>
>> For example 10 April 2020 to 21 September 2020, your condition becomes
>>
>> Day >=10 And Month = 4
>> Or Month >4
>> Or Day <=21 And Month=9
>> Or Month<9
>>
>> Month>4 Or Month<9 covers the whole year !
>>
>> Tricky isn't it.
>>
> [...]
> 
> Good point. Parameterize the date ranges just to keep the query 
> relatively simple. For example:
> 
> StartDate = Day >= 10 and Month = 4
> EndDate = 21 and Month = 9
> MonthRange = Month > 4 AND Month < 9
> 
> SELECT *
> WHERE RecDate = StartDate
> OR RecDate = MonthRange
> OR RecDate = EndDate
> 
> 
Or just modify the SQL to:

WHERE
Day >=10 AND Month = 4
OR Month >4 AND Month <9
OR Day <=21 AND Month=9

For dates across years:

WHERE
Day >=7 AND Month = 11
OR Month >11 AND Month <1
OR Day <=14 AND Month=1


-- 
best regards,

Neil

Thread

Need some SQL Keith Tizzard <internet.shopping@foobox.com> - 2021-08-12 04:27 -0700
  Re: Need some SQL Ammammata <ammammata@tiscalinet.it> - 2021-08-12 13:11 +0000
    Re: Need some SQL Ammammata <ammammata@tiscalinet.it> - 2021-08-12 13:12 +0000
  Re: Need some SQL Ron Paii <ron81pai@gmail.com> - 2021-08-12 08:11 -0700
    Re: Need some SQL Ron Paii <ron81pai@gmail.com> - 2021-08-12 08:13 -0700
      Re: Need some SQL Keith Tizzard <internet.shopping@foobox.com> - 2021-08-12 08:20 -0700
        Re: Need some SQL Ron Paii <ron81pai@gmail.com> - 2021-08-12 10:37 -0700
          Re: Need some SQL Keith Tizzard <internet.shopping@foobox.com> - 2021-08-12 10:48 -0700
            Re: Need some SQL Ron Paii <ron81pai@gmail.com> - 2021-08-12 11:55 -0700
              Re: Need some SQL Keith Tizzard <internet.shopping@foobox.com> - 2021-08-12 14:05 -0700
                Re: Need some SQL Neil <neil@myplaceofwork.com> - 2021-08-13 11:41 -0400
  Re: Need some SQL Ron Weiner <rw@domain.com> - 2021-08-13 12:50 -0400
    Re: Need some SQL Keith Tizzard <internet.shopping@foobox.com> - 2021-08-14 03:40 -0700
      Re: Need some SQL Ron Weiner <rw@domain.com> - 2021-08-14 10:36 -0400
        Re: Need some SQL Keith Tizzard <internet.shopping@foobox.com> - 2021-08-14 09:17 -0700
          Re: Need some SQL Ron Weiner <rw@domain.com> - 2021-08-14 12:28 -0400
          Re: Need some SQL Ron Weiner <rw@domain.com> - 2021-08-14 12:31 -0400
            Re: Need some SQL Ammammata <ammammata@tiscalinet.it> - 2021-08-14 22:09 +0000
              Re: Need some SQL Keith Tizzard <internet.shopping@foobox.com> - 2021-08-15 03:30 -0700
                Re: Need some SQL "mal....@gmail.com" <mal.reeve@gmail.com> - 2021-08-15 04:54 -0700
                Re: Need some SQL Ron Weiner <rw@domain.com> - 2021-08-15 09:27 -0400
                Re: Need some SQL Neil <neil@myplaceofwork.com> - 2021-08-15 10:54 -0400
                Re: Need some SQL Neil <neil@myplaceofwork.com> - 2021-08-15 11:17 -0400
                Re: Need some SQL Ron Weiner <rw@domain.com> - 2021-08-15 12:03 -0400
                Re: Need some SQL Neil <neil@myplaceofwork.com> - 2021-08-15 13:04 -0400
                Re: Need some SQL Ron Weiner <rw@domain.com> - 2021-08-15 13:23 -0400
                Re: Need some SQL Neil <neil@myplaceofwork.com> - 2021-08-15 16:56 -0400
                Re: Need some SQL Ron Weiner <rw@domain.com> - 2021-08-15 17:13 -0400
                Re: Need some SQL Neil <neil@myplaceofwork.com> - 2021-08-16 13:11 -0400
                Re: Need some SQL Keith Tizzard <internet.shopping@foobox.com> - 2021-08-16 11:16 -0700
                Re: Need some SQL Neil <neil@myplaceofwork.com> - 2021-08-16 15:05 -0400
                Re: Need some SQL Neil <neil@myplaceofwork.com> - 2021-08-16 15:46 -0400
                Re: Need some SQL Keith Tizzard <internet.shopping@foobox.com> - 2021-08-16 14:51 -0700
                Re: Need some SQL Neil <neil@myplaceofwork.com> - 2021-08-16 20:11 -0400
                Re: Need some SQL Neil <neil@myplaceofwork.com> - 2021-08-16 21:54 -0400
                Re: Need some SQL Neil <neil@myplaceofwork.com> - 2021-08-17 02:50 -0400
                Re: Need some SQL Ron Weiner <rw@domain.com> - 2021-08-15 14:47 -0400
                Re: Need some SQL Keith Tizzard <internet.shopping@foobox.com> - 2021-08-15 12:35 -0700
                Re: Need some SQL Ammammata <ammammata@tiscalinet.it> - 2021-08-17 08:16 +0000
                Re: Need some SQL Ron Weiner <rw@domain.com> - 2021-08-19 17:30 -0400
  Re: Need some SQL Mike P <mikewpayne@tiscali.co.uk> - 2021-08-19 02:26 -0700

csiph-web