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
