Search results

Super! Thank you, I used a text box and used the expression builder as the control source. Works perfectly. Thanks again for all your help.

Here's where I embarrass myself! All I have ever done in the past is add existing fields into a form by dragging from the list on the right hand side. How do I add a field with a control source?

Sorry - I am probably not explaining this very well at all. The issue seems to be that because I am using a calculated field, it is locking all dependent fields to long integers... so it will not allow any decimal places in the 'time taken' fields. I think I need to scrap the calculated field...

That is one solution but I always find inputing minutes in the time format rather cumbersome. The staff who enter the time recording do it on the form, so it only really needs to display the calculation on the form. Sorry for the total noob question - but how do I do that?

Many thanks. Yes, I guess the real issue is that the number format cannot be changed in the calculated field. The fields contain numbers of hours in a day against activities, so they need to be in 15 min resolution, e.g. 1.25 hrs. Then I wanted the total hrs column to automatically add up the...

Thanks for the reply. Yes it is set to long integer and cannot be changed. This also seems to be the case for all the fields it depends upon??

Hi all, Access 2010. Not an expert with Access by any means but I thought this would be very simple! Have a table with columns of data which I want to total at the end of each row. The Calculated Field does this simply enough but it only seems to be able to add whole integers? How do I get it...