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
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,
OvertimeRate1 as overtimerate,
OvertimeWorked1 as overtimeworked,
Concatenate SQL Select FullName,
OvertimeWorked2 as overtimeworked,
OvertimeRate2 as overtimerate
SQL Select OvertimeYear as Year,
The data is sort of linked but shows all values within a list box
2016 - qry_AllData
2017 - qry_AllData
2016 - tbl_OvertimeBudget
2017 - tbl_OvertimeBudget
How to link these two data sources?
Many thanks for looking