Ran the expression with "n" and changed 24 to 1440 and that's giving me the answer I want.
Thank you very much!
When I click on the query to open it, it's acting like a parameter query. It opens up asking me to enter a parameter value for "n". I input "n" and up comes my query.
I don't want to have it work this way. I prefer it to just open.
I'm thinking I need to add another field to the query representing the "n" value, so that it doesn't keep asking for it when I open it up???
Not sure just what I need to do.
I've been looking for some good books that I can reference to help me learn some of this "creating expression" stuff. Can you recommend one? or a detailed help site on the web?
I noticed when I pasted this expression in that I had an error in the first portion of it.
According to the original expression I pulled off the web help site, I should have EndTime2 in the second half of this. I went back and changed it, but it returns the incorrect time worked?
I attached the database so you can see what I've done.
When these guys go on shift, they count the time worked as the entire time they're away. They still need to keep track of their actual "working" hours spent on the train separate from their time spent at the bunkhouse, so hence the 2 different date and time fields.