I am working on a form that has lots for formulae in it. In one particular field I need it to look at two other fields and pick up the largest figure between the two. The two fields that it is looking have both positive and negative numbers in them and it does not recognise that -0.007 is greater then 0.006. Do you know what I can do to remedy this?
Help with an Expression
- Thread starter Chineham
- Start date
Ally
Registered User.
- Local time
- Today, 14:05
- Joined
- Sep 18, 2001
- Messages
- 617
Maybe I am completely dense, but surely -0.007 (being a minus figure) is less than 0.006 (being a positive figure). If you are talking about being the greatest deviation from zero then it is -0.007 - this being the case, then perhaps you need to change your code slightly are it sounds like your code is looking for the greater figure.
R
Rich
Guest
Look up the Abs function.
