Recent content by gh444

Thanks for the tips everyone. Will have a rethink about the nature of my data.

Thanks but I've tried that and I'm getting a #Type! error in the form field

Hi, A working shift is 8 hours. Anything in excess of that is overtime. I want to display on a form overtime hours and minutes calculated as a duration in excess of eight hours. It needs to work over midnight. I have the following to work out a shift duration...

Thanks Steve. Come to think about it I do have the date elsewhere on the parent form and I could bring that into play. Alternatively as you say it doesn't really matter what date the calculation uses as jobs are always contained within an 8 hour work shift. Hope you enjoyed your Christmas...

Thanks for the contributions everyone. I should have mentioned that my data only has 'times' to work with. My users didn't like to type short time format into a form and requested 'something like Outlook has', selecting times from a drop down list. I've done this with two combo boxes, one for...

Hi, I want to calculate decimal hours duration taken for a job starting before and finishing after midnight. I have something that works but it seems cumbersome. Can anyone suggest a more elegant solution than the following: Hour(Format([Job]![Start_time]-1-[Job]![Finish_Time],"Short...

Must have been that my forms were not properly related. I've rebuilt them and everything seems okay. Got it into my head that it was an issue with combo boxes. Thanks for steering me away from that. Your reply much appreciated.

Hi, I have a main form with the composite key: Machine_ID (Text selected from a combo box) Shift_date (Using calendar control) Shift_start_hour (Text selected from a combo box) I have a sub-form with the composite key: Machine_ID Shift_date Shift_start_hour batch_no (Free text entry) I create...