Relationship among two tables with relative date ranges (1 Viewer)

Hello everyone, I am here for the first time. I am trying to relate two tables in access from the menu Tools>Relationships:

The first Table is:

Table_GANTT

ID BeginningDate EndingDate Event
1 18/01/2019 21/01/2019 A
2 21/01/2019 31/01/2019 B
3 31/01/2019 30/03/2019 C

The Second Table is

Table_EVENTS

ID Date
1 19/01/2019
2 20/01/2019
3 21/01/2019
4 22/01/2019
5 22/02/2019
6 23/02/2019

I'd like to relate Table_EVENTS to Table_GANTT
so that each Date in Table_EVENTS is related to an Event in Table_GANTT.
Basically, I'd like to associate to each date in Table_EVENTS an Event which happen in a range of date.

In Filemaker
from the menu "Manage Database>Relationships"
it is sufficient to link
Table_EVENTS.Date to both Table_GANTT.BeginningDate and Table_GANTT.EndingDate and state
Table_EVENTS.Date>=Table_GANTT.BeginningDate
And
Table_EVENTS.Date<Table_GANTT.EndingDate
Then All the data in the tables are referenced

How is it possible to do this in Access?? I'd like to make a true relation not a query.

Thanks a lot for your time and help

Hi. I’m not sure this is possible using Access. I’m not even sure if it’s possible using SQL Server. Why would a query be not sufficient? Just curious...

I don't think it's possible in relationships either. It is possible in a query (non-equi join).

Well.. actually I am creating a Form with SubForm to add data and I'd like to display these information there. I am not sure it will be possibile with a query. In my previous experiments with Filemaker I've got something like the one I attached.

not sure it will be possibile with a query

Click to expand...

You most definitely will be able to do a query on a range using the BETWEEN operator.

https://www.w3schools.com/sql/sql_between.asp

Thanks a lot.. I did it

I must have misunderstood the goal; I don't see how Between would "associate to each date in Table_EVENTS an Event which happen in a range of date".