Still a noob looking for help

From: Dave (none_at_none.net)
Date: 05/19/04

  • Next message: Ken: "Update data from DBGrid" 
    Date: Wed, 19 May 2004 21:15:39 +0100

    Hi i am about to try and make an application to input work times from
    employees. I have the data in the form of:

    Employee,jobNo,
    then the rest of the data is in man hours for each stage of the job.

    i.e Fabrication, Painting,Mechanical,Electrical,Topping

    now i am hoping to collate all the hours from each employee, who may work on
    different jobs during the week (e.g more than one person may paint) . I want
    to collate all the hours into a sensible format with all the totals from
    each employee totaled up into each individual title.

    hope this makes sense, ideas or links appreciated.

    Have a little understanding so be gentle with me.

  • Next message: Ken: "Update data from DBGrid"

    Relevant Pages

    • Re: Struggling with query
      ... What I mean is the result should be per accident if Albert had 2 accident and ... SELECT SUM(TA1.[Total by Employee]) ... FROM [tbl EmployeeAccident] EA1 ... Really to show you how to identify these totals, I must first know where all ...
      (microsoft.public.access.queries)
    • Re: Struggling with query
      ... SELECT [tbl Employee Accident].AccidentID, [tbl Employee ... How are you accomplishing these totals? ... They are suppose to work like this Albert reported 2 accidents in the ...
      (microsoft.public.access.queries)
    • Re: Struggling with query
      ... "Tom Ellison" wrote: ... SELECT SUM(TA1.[Total by Employee]) ... FROM [tbl EmployeeAccident] EA1 ... Really to show you how to identify these totals, ...
      (microsoft.public.access.queries)
    • Re: Need Subforms?
      ... pkeyEmployeeTypeId = AutoNumber ... Employee Last Name ... combo box that will populate next field, ... totals of overtime hours worked. ...
      (microsoft.public.access.forms)
    • Re: Im stuck can not get total sum correct
      ... Just can not get the grand total for all the accidents ... "Duane Hookom" wrote: ... fine but each employee is assigned to one department only. ... the totals are not ...
      (microsoft.public.access.reports)