Home » Developer & Programmer » Forms » nearly there, but not quite Pratap, not sure what is happening
nearly there, but not quite Pratap, not sure what is happening [message #78628] Wed, 06 March 2002 04:24 Go to next message
nik
Messages: 55
Registered: January 2002
Member
Thank you for your suggestion, I have been using similar construct, I have used your
construct from forum and I am nearly there but it seems to be suppressing the zero, see all
"wrongs" in table below. some are correct. I have been trying all sorts of format masks
on "f_1" fields, but no luck. Any more ideas Pratap.

Thanks.
Nik.

I am getting the results, below, after using your construct.

hrs mins *calculated
*result
-----------------------------------------------
2-------64 *3.4 --correct three hours/4 mins
9 0 *9 --correct
0 50 *.5 --wrong(50) 50 mins
3 132 *5.12 --correct
6 90 *7.3 --wrong(7.30) seven hours /30 mins
9 30 *9.3 --wrong(9.30) nine hours/30 mins
Re: nearly there, but not quite Pratap, not sure what is happening [message #78632 is a reply to message #78628] Wed, 06 March 2002 05:40 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
set the format mask 99.99
Previous Topic: time problem
Next Topic: I have tried that , it works for some, but when ......
Goto Forum:
  


Current Time: Wed Feb 08 04:59:47 CST 2023