Okay... I've put down my bag of paintchips and I've promised not to eat anymore of them [at least for today]. So know I'm going to ask since I'm having a catastrophic brain fart
.
I cant figure out how to get Acces [and I swear I can remember doing this before] to take a start time and subtract it from an end time to get s time spent for a project...
the fields are all in the same table.
TIn
TOut
TTotal
They're all in short time format [ie military time]. The only way I can think of it is to make a module that'll do it and then have TTotal reference the MTTotal [module].
But here's where the brain fart comes in... I cant remember the way I need to set up the module. Haven't touched VB in tooooooooooooooooooo long.