Re: Time fields

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ken Snell (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 05/31/04

  • Next message: nahla fadel: "exe fichier access" 
    Date: Mon, 31 May 2004 14:10:42 -0400

    Use a query. Put two calculated fields in the query: one to calculate the
    time difference and the other to calculate the money.

    HoursWorked: DateDiff("n", [StartTime], [EndTime]) / 60

    MoneyEarned: DateDiff("n", [StartTime], [EndTime]) / 60 * [PayPerHour] 

    -- 
        Ken Snell
<MS ACCESS MVP>
"jim russell" <jimrussell@jrussell90.freeserve.co.uk> wrote in message
news:ONILeezREHA.2520@TK2MSFTNGP11.phx.gbl...
> how do you work out the difference between a start time and a stop time,
and
> use the answer to
> work out how much money you would earn during that period
> of time.  I know it sounds easy< no problem in excell but access ??????
>
>
  • Next message: nahla fadel: "exe fichier access"

    Relevant Pages

    • Re: What am I doing wrong?
      ... Tell us what data records you want the query to show you. ... <MS ACCESS MVP> ... (The first has electric consumption & money, ...
      (microsoft.public.access.queries)
    • Re: DateDiff Problem
      ... You will need to get the time difference in minutes, ... Ken Snell ... <MS ACCESS MVP> ... > are entered daily and the query is as follows: ...
      (microsoft.public.access.queries)
    • Re: Please Help with Query Calculations
      ... As for the other fields I put SUM but its not summing them up. ... of the query, go up to View and select Totals. ... maybe a few more fields) and an Sum the Amounts Owed and Amounts Paid ... is several dates of when people were billed money and paid money. ...
      (microsoft.public.access.queries)
    • Re: time calculation problem
      ... The time difference between Birth and Placenta would not need ... subsequent query, form or report. ... automatically fill a part of the form with this calculation once i have ...
      (microsoft.public.access.gettingstarted)
    • Re: Doctors Income
      ... That you pose the query you do in the vague/open-ended form in a way ... Even way out here in the bowels of fly-over country, I'm often pleasantly surprised to discover the depth and breadth of info that the libraries place at my fingertips. ... Of course, every other budget cycle the libraries are targets for the politicians who want to spend the money on sexier projects, so vigilance is always necessary. ...
      (soc.retirement)