is date in range of two fileds?

[sal21]

I need a SQL, to check if myvardate=26/02/2021 is in range DAL to AL where TIPO='8-SINGOLA'

in my case the condition is true

note:
i'm working with vb6
attached image with my Access table

https://files.engineering.com/getfi...dd07-4a71-a504-47ec1936d218&file=Immagine.jpg

 

[Andrzejek]

What have you tried so far? Any code / SQL? Even if it does not work...

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson