data linking

spikenaylor1 — Mon, 01 Aug 2016 17:36:59 GMT

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

Re: data linking

spikenaylor1 — Thu, 04 Aug 2016 14:06:42 GMT

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

Many Thanks