Results 1 to 2 of 2

Thread: sum time

  1. #1
    Join Date
    May 2009

    Unanswered: sum time

    hi everybody

    i have a qry that gives me attendance information of employee
    i have two calculated fields in the qry...

    late time
    early time

    i use this qry in a form

    in the form footer i try to sum the above 2 fields ...i get #error

    i used sum([late time])

    i tried dsum and dint give me results.....same....#error

    any help will be appreciated

    thanking you

  2. #2
    Join Date
    Jan 2012
    Can you post SQL for this query? What is the format for the fields 'late time' and 'early time'? Are they a number or date/time? How are these fields calculated? What are they calculated from?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts