I have an Access 2007 database which was working happily in Windows XP Pro SP2. I have just upgraded to Windows 7 and all of a sudden some calculations in my forms and subforms are not working. Below is a typical example:-
=Format(Int([TotalAccrued]/3600),"00") & ":" & Format(Int(([TotalAccrued]-(Int([TotalAccrued]/3600)*3600))/60),"00") & ":" & Format((([TotalAccrued] Mod 60)),"00")
Can anybody tell me what setting I need to adjust in order to get the results of these formulas back.
Thank you very much in advance.
Rob
=Format(Int([TotalAccrued]/3600),"00") & ":" & Format(Int(([TotalAccrued]-(Int([TotalAccrued]/3600)*3600))/60),"00") & ":" & Format((([TotalAccrued] Mod 60)),"00")
Can anybody tell me what setting I need to adjust in order to get the results of these formulas back.
Thank you very much in advance.
Rob