form question

[thierry14]

Hi,

I've got a form that displays a list as follows:
Name Number
xyz 2
xyz 1
xyz 3
xyz 4
xyz 3

I want to add a text box that will look at the numbers listed and display the highest number? Not really sure how to go about it, an if statement maybe?

thanks for your help.

 

[MStef]

Look at "DemoHighestNumA2000.mdb"

 

[ansentry]

Have a look at the sample, is this what you want.

 

[thierry14]

hi
thanks ansentry that is what i was after, one thing though, can i have the text box = a word, as in if its 3 then textbox = yes, 2 textbox = no etc?
thanks very much

 

[ansentry]

The answer is yes; give me a list of numbers and the word that you want to associate with it;

# Word
1) Yes
2) No
3)
4)
5)
Etc

 

[thierry14]

well its just 4 numbers...

1 yes
2 no
3 likely
4 unlikely

thanks!

 

[ansentry]

Have a look at the attached sample. I used a combo box in lieu of a Option Group.