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?
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
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...