Hi,
I wanted to get the first digit from a 5 digit identification number, and
thought that I could use the formula Floor(IDNUMBER/10000). However when I
try to use the formula I get a node-test expected error.
I'm not sure what I'm doing wrong and appreciate any help
Thanks
Rohan
Scott L. Heim [MSFT] - 04 Aug 2005 18:13 GMT
Hi Rohan,
Try this:
floor(select your field) / 10000
** NOTE: Notice the "space" before and after the division symbol - this is
needed.
Let me know if this helps!
Scott L. Heim
Microsoft Developer Support
This posting is provided "AS IS" with no warranties, and confers no rights