Aug 13 2005, 01:07 AM
I have a table which stores numbers between 0 and 99.
I would like these values to be displayed as numbers between 1 and 20.
I have tried using an expression on the text box along the lines of:
However, this has returned an error.
What I would like it to return is something like the following:
For example - 0 to 4 would return 1, 5 to 9 would return 2 and so on...
Any ideas on how I could implement this? As I will be using the same thing multiple times it wouldn't be practical to have a table used for each conversion.
Aug 13 2005, 02:14 AM
You can do this using the \ Operator.
x = 0
? x\5 + 1
x = 99
? x\5 + 1
HTH - craigo
Aug 13 2005, 08:07 AM
That doesn't seem to have done the trick, still returns an error message I'm afraid.
Aug 13 2005, 08:30 AM
What is the datatype of the [number] field? Make sure it is a number and not text.
Aug 13 2005, 11:15 AM
What error message is it returning?
Aug 13 2005, 11:54 AM
The field type is a number. All the text box returns is '#Error'.
Aug 13 2005, 02:11 PM
Is the name of your textbox the same as the field you are using in the calculation? If it is change the name of the textbox so they aren't the same.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here