Search results

  1. K

    Can't save changes to a form

    Hoping someone can help with this. No matter what I do I can't save changes to a form I created about 6 months ago. I was able to when I first created it. In searching for similar problem I came across info that seemed to indicate there's 'maintenance' to be done for databases every once in...
  2. K

    Access duration calculation

    Oh my. I changed INT to FIX, that didn't work, but when I changed it to 'ROUND' the calculations seem fine - do you see any ramifications of doing that? And again, thanks for your help; your 'INT may be truncating' gave me different wording to search for...
  3. K

    Access duration calculation

    Thanks, I think I'm in over my head. I've run 3 weeks worth of durations and no other calculations are invalid - - only when the seconds are the same number in both the start and end times. And it's always one hr less. I think I KNOW I'm in over my head !! I don't round anything, it all comes...
  4. K

    Access duration calculation

    Hi! I'm new here; hoping someone else has run into this and can help. I'm calculating durations; recently added =Format(Int([text48]/60) & ":" & [text48] Mod 60,"Short Time") to 'Issue Duration' Control Source where text48 is the calculation: =((([Issue Ended]-[Issue Started])*24)*60)...
Back
Top Bottom