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:
=([number]/5)

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.

Cheers,
Rob.

Rob,

You can do this using the \ Operator.

Example:

x = 0
? x\5 + 1
1

x = 99
? x\5 + 1
20

HTH - craigo

That doesn't seem to have done the trick, still returns an error message I'm afraid.

What is the datatype of the [number] field? Make sure it is a number and not text.

HTH,

What error message is it returning?

craigo

The field type is a number. All the text box returns is '#Error'.

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.