I'm creating a adp from a mdb. In the old mdb i had a form that held sessions that lecturers worked and in the form footer i had a text box which had a control source =Sum([hrs])*24 and this worked fine. now in the adp this does not work the field just returns error. Can anyone give me any advice on this please.