Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could anyone help or point me to the correct resource to try and figure this out please
Many Thanks