Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Average from a field...

Discussion in 'Information Technology' started by Red2003XLT, Jul 28, 2006.

Tags:
  1. Red2003XLT

    Red2003XLT
    Expand Collapse
    Guest

    Hello all

    Building on this code
    Duration: (DateDiff("n",[StartWork],[EndWork]))\60 &
    Format((DateDiff("n",[StartWork],[EndWork])) Mod 60,"\:00")

    I'm in need of the same type of caluclating time except, I need to carry it
    too seconds plus do an average, a max, and a mini per month

    Help

    "Rick B" wrote:

    > You don't need to click a button.
    >
    > In the query, upon which your form is based, simply add a new column with
    > something like...
    >
    > Duration: (DateDiff("n",[StartWork],[EndWork]))\60 &
    > Format((DateDiff("n",[StartWork],[EndWork])) Mod 60,"\:00")
    >
    > That would allow you to drag the field name "Durration" from your forms
    > Field List into your forms or reports. The above would format it as HH:MM.
    > You can , of course, replace it with whatever formula you are currently
    > using to perform this calculation. You say you are using an update query to
    > update the value, so you obviously already know how to calculate it.
    >
    > You could also just put it in the unbound field in a form or report. For
    > example, add a new unbound field to your form and put something like...
    > =(DateDiff("n",[StartWork],[EndWork]))
    >
    > or
    >
    > =(DateDiff("n",[StartWork],[EndWork]))\60 &
    > Format((DateDiff("n",[StartWork],[EndWork])) Mod 60,"\:00")
    >
    >
    > --
    > Rick B
    >
    >
    >
    > "denelson" <Daniel.Nelson.00@gmail.com> wrote in message
    > news:1146149841.543994.9930@e56g2000cwe.googlegroups.com...
    > > Ok well how could I go about doing this. I'm not quite understanding
    > > this concept. I understand your concerns, just the process you suggest
    > > is what I don't understand. I have a start date and a stop date. That
    > > is stored... fine. Now What would be my next move. I have a form I
    > > created which is a template. I want to click the button on the form and
    > > it tell me the average time it took... How can I go about this.
    > >

    >
    >
    >
     
  2. Loading...

    Similar Threads Forum Date
    Sikhi About The Average Sikh Sikh Sikhi Sikhism Feb 18, 2016
    India Corruption rate in India is double of global average Breaking News Jul 9, 2013
    Average Jatt Sikh Male Height 5' 7" Health & Nutrition Aug 7, 2010
    Tech turns average Joes into mini-Spielbergs (USATODAY.com) Interfaith Dialogues Apr 1, 2005
    Canada Huddersfield Sikh community leader Bakhshish Singh Bhullar dies... Breaking News Jan 27, 2014

  3. Red2003XLT

    Red2003XLT
    Expand Collapse
    Guest

    Re: Average from a field...Add more information

    Building on this code
    Duration: (DateDiff("n",[StartWork],[EndWork]))\60 &
    Format((DateDiff("n",[StartWork],[EndWork])) Mod 60,"\:00")

    I'm in need of the same type of caluclating time except, I need to carry it
    too seconds plus do an average, a max, and a mini per month

    My Start and End Dates are variable sometimes just a few seconds upward to a
    couple of months.

    Help


    "Red2003XLT" wrote:

    > Hello all
    >
    > Building on this code
    > Duration: (DateDiff("n",[StartWork],[EndWork]))\60 &
    > Format((DateDiff("n",[StartWork],[EndWork])) Mod 60,"\:00")
    >
    > I'm in need of the same type of caluclating time except, I need to carry it
    > too seconds plus do an average, a max, and a mini per month
    >
    > Help
    >
    > "Rick B" wrote:
    >
    > > You don't need to click a button.
    > >
    > > In the query, upon which your form is based, simply add a new column with
    > > something like...
    > >
    > > Duration: (DateDiff("n",[StartWork],[EndWork]))\60 &
    > > Format((DateDiff("n",[StartWork],[EndWork])) Mod 60,"\:00")
    > >
    > > That would allow you to drag the field name "Durration" from your forms
    > > Field List into your forms or reports. The above would format it as HH:MM.
    > > You can , of course, replace it with whatever formula you are currently
    > > using to perform this calculation. You say you are using an update query to
    > > update the value, so you obviously already know how to calculate it.
    > >
    > > You could also just put it in the unbound field in a form or report. For
    > > example, add a new unbound field to your form and put something like...
    > > =(DateDiff("n",[StartWork],[EndWork]))
    > >
    > > or
    > >
    > > =(DateDiff("n",[StartWork],[EndWork]))\60 &
    > > Format((DateDiff("n",[StartWork],[EndWork])) Mod 60,"\:00")
    > >
    > >
    > > --
    > > Rick B
    > >
    > >
    > >
    > > "denelson" <Daniel.Nelson.00@gmail.com> wrote in message
    > > news:1146149841.543994.9930@e56g2000cwe.googlegroups.com...
    > > > Ok well how could I go about doing this. I'm not quite understanding
    > > > this concept. I understand your concerns, just the process you suggest
    > > > is what I don't understand. I have a start date and a stop date. That
    > > > is stored... fine. Now What would be my next move. I have a form I
    > > > created which is a template. I want to click the button on the form and
    > > > it tell me the average time it took... How can I go about this.
    > > >

    > >
    > >
    > >
     

Share This Page