Calculating total hours that cross midnight.

[cdh]

I am trying to create an expression that calculates the total hours worked that may or may not cross midnight. I am using 2007 with colums titled Start Date, End Date, Start Time, End Time, and Total Hours. I need this to work in both forms and reports. Can anyone please help?

[RuralGuy]

THis link should help: http://www.mvps.org/access/datetime/date0004.htm

[cdh]

Works great

[RuralGuy]

Glad we could help.

[cdh]

Ok so that solved the issue of calculating the total time, now when i try to get the total time (calculated field) to multiply by the hourly rate (input value) it gives me an error. I know this should be easy to figure out, but it has agrivated me. How can i perform a calculation on a calculated field?

[RuralGuy]

Do the calculation in the AfterUpdate event of the control where you input the Hourly Rate.

[cdh]

Ok, so I think I did what you asked correctly, however it didn't change anything. I have attached the database for you to review and see what can be done to make it work. I am working on the Required Positions Form. Thanks for all your help.

Attachment removed at the request of the poster - RG

[pbaldy]

Note the follow up question has been asked elsewhere:

https://www.accessforums.net/access/...orts-5829.html

[RuralGuy]

Thanks Paul. cdh: we will let the other thread come up with the solution. I am going to lock this thread for now.