I have a database that is being converted to XP. I have a field on a report that is called DURATION. DURATION is the difference between COMPLETE and FIRST_TC in minutes. In ACCESS 97, on the report I formatted the field to (=Format([DURATION],"hh:nn")). This forces the minutes to be converted into hours and minutes and it works great.
Well, in ACCESS XP, when you put the formatting in (=Format([DURATION],"hh:nn")) it automatically converts it to =Format([DURATION],"Short Time"), obviously because "HH:NN" is the defined "Short Time". The problem is that it doesn't work, it gives the famous #ERROR in that field when the report is ran. Also, I have tried the input mask and the format property in the properties box.
If anyone has any suggestions, I would appreciate it!!
Thanks in advance.
jodom
LUCK - WHERE PREPARATION MEETS OPPORTUNITY!!
Well, in ACCESS XP, when you put the formatting in (=Format([DURATION],"hh:nn")) it automatically converts it to =Format([DURATION],"Short Time"), obviously because "HH:NN" is the defined "Short Time". The problem is that it doesn't work, it gives the famous #ERROR in that field when the report is ran. Also, I have tried the input mask and the format property in the properties box.
If anyone has any suggestions, I would appreciate it!!
Thanks in advance.
jodom
LUCK - WHERE PREPARATION MEETS OPPORTUNITY!!