Recent content by ICS

Please Help I am new at writing expressions in expression builder ,I have a tab form with 3 tabs I am trying to show the totals of job collected from the tabs at the bottom of the first tab. This is what I wrote and I keep getting an #Error. =DLookUp("[total Travel Hrs]","Time card...

i have created a report that has the site numbers for the jobs i set up a micro on the site number field to open the form that has all of the information of that site. I get the error message The object doesn't contain the automation object'form' i am not sure how to correct it. Can any one help?

Thank you that help alot.

In Excell you can go to 13:00 and it will calculate it right in Access it doesn't unless i am doing something wrong on the formula ie Total:([Time_Out]-[Time_In])*24

I have created a time sheet in reports that calculates the time from a spread sheet input Time_In and Time_Out. The problem is if we work from 9:00pm till 1:00am i will get a negitive number. does any one have a answer how to do this where it wold be 4 hrs not -20

Thanks that really worked great

I am building a Time card db and have run into a problem, my fields are Sun_in then Sun_out and so on. i put a total at the end of the form and set up the expression builder as so ([Mon_Out]-[Mon_In])+([Tue_Out]-[Tue_In])*24 The problem is if on of the fields is blank the total will be blank...