Recent content by NormFY2

err... it's a feature of access I was forced to get to grips with yesterday... just thought I'd share ... and now the thread is current!

A bit fiddly this one - I had a sum of durations presented from the query, so I used the Format function to get the hours and minutes part separately. Converted it all into seconds - (Magic Numbers are 3600 times hours, 60 times minutes), then divided the (CInt converted the Format strings to...

Hi all, Access Programmer (of sorts), SQL and VBA are my main things...