A good afternoon,
I have a table CDNUM with the following columns
ID Random
1 50
4 60
6 30
3 20
5 20
2 10
I want in a form in Visual Basic a event procedure so that he looks in the column of ID for the highest value and then in the Column Random (in the corresponding record) add 5
when I do this
[Random] = DMAX ("RANDOM", "CDNUM") + 5
then it will look in the second column for the highest part and add 5 : so here it will be 65
I want that the highest part in column ID and then that it gives me 35
kindest regards