data linking

[spikenaylor1]

I have one ms access database for overtime recorded.

one query contains majority of data

one table contains overtime budget for each year.

Struggling to get the two linked

LOAD *,

     MonthName([OvertimeDate]) as Month,

     QuarterName([OvertimeDate]) as Quarter,

     WeekName([OvertimeDate]) as Week,

     Yearname([OvertimeDate]) as Year;

ODBC CONNECT32 TO [MS Access Database;DBQ=E:\Database1.accdb];

SQL Select Company,

    FullName,

    HoursCashed,

    OvertimeDate,

    OvertimeRate1 as overtimerate,

    OvertimeWorked1 as overtimeworked,

    Processes,

    Shift,

    strClassName,

    ToilTaken,

    TotalCost

FROM "E:\Database1.accdb"."qry_AllData";

Concatenate SQL Select FullName,

     OvertimeDate,

    OvertimeWorked2 as overtimeworked,

    OvertimeRate2 as overtimerate

    FROM "E:\Database1.accdb"."qry_AllData";

SQL Select OvertimeYear as Year,

    OvertimeBudget,

    OvertimeBudgetID

FROM "E:\Database1.accdb"."tbl_OvertimeBudget";

The data is sort of linked but shows all values within a list box

ie.

2016 - qry_AllData

2017 - qry_AllData

2016 - tbl_OvertimeBudget

2017 - tbl_OvertimeBudget

How to link these two data sources?

Many thanks for looking

[spikenaylor1]

Could anyone help or point me to the correct resource to try and figure this out please

Many Thanks