Post reply

Sum hours

  • June 1, 2005 at 4:06 am

    #562123

    Michael,

    The conversion process from MDB to SQL may have created a different field type. Check that it is a numeric field. Also - in case there are nulls use the NZ function ie sum(nz([hrs],0).

    Why use an ADP anyway?  Why not just link the tables and use DAO - its faster from tests that I've tried.

     

    Richard

     

  • June 1, 2005 at 4:10 am

    #562126

    The hrs field is a short time field

  • June 1, 2005 at 6:18 am

    #562138

    You mean smalldatetime?

  • June 1, 2005 at 6:33 am

    #562143

    Try something like this in the datasource of the textbox :

    =DateDiff("h";[StartDate];[EndDate])

    then at the bottom of the report you should be able to use sum([txtboxname])

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply