conditional formatting

  • Thread starter Thread starter 2Stupid2ownAputer
  • Start date Start date
2

2Stupid2ownAputer

Hello,
ID = 123 .01 (primary key)
conditional formatting change field colour
[id]-Int([id])=0.01

ID _ INT(ID)
123.01 -123 = 0.01
any ideas why this doesn`t work?
I tried format as well to no avail
regards
 
2Stupid2ownAputer said:
ID = 123 .01 (primary key)
conditional formatting change field colour
[id]-Int([id])=0.01

ID _ INT(ID)
123.01 -123 = 0.01
any ideas why this doesn`t work?
Click to expand...


It's a floating point numbers thing. Try this

Int(ID * 100) - Int(ID) * 100 = 1
 
Thanks for that marsh
I knew It had to be something with the numbers but couldn't`t figure out
what to do about
Best regards
 
Back
Top