Recent content by Big_Rob

I need help writing a statement. [Text1Qty] [Text2Qty] [Text3Qty] The three quantities will vary, but i need to display the text box with the lowest quantity only.... Thanks in advance.....

Re: Midnight Time calculation Help....SOLVED!!! I stay away from the BS that usually fills most forums... Galaxiom, thanks for actually attempting find a solution...although, I didn't try yours. I had posted the same question in various places. Code: =IIF(Endtime-StartTime<0...

Still looking....but nothing out there?

I'm an Access rookie.... There has to be someone out there that can modify this for midnight... =[End Time]-[Start Time]

I've googled the heck out of this subject and can't believe that there's nothing out there for this....

New guy here...Using v2007. I have a db used in manufacturing and in a machining report I capture [Start Time] and [End Time] (=[End Time]-[Start Time]). I only record Time (short) and not date/time. I can't used DateDiff. The problem occurs on the 3rd shift when end time is past midnight...