OBtaining the Max Value of several text boxes Values

[ruthib4]

Hi Everyone,
Hope you are ok.

I am trying to obtain the maximum valueof several text boxes a i am using in a form. I know there is Dmax but not sure how to use it.



Thanks in advance

[June7]

Form in continuous view, put textboxes in form footer with expression like:

=Max([fieldname])

If the fields are number type and form in datasheet view, click the totals button on ribbon to open a Totals row, select Maximum below the fields.

[ruthib4]

Thanks a lot June7

its is working now, please close the thread as Solved.

Cheers