1 Reply Latest reply: Aug 4, 2016 10:06 AM by Michael Taylor RSS

    data linking

    Michael Taylor

      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