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

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?

Dave