I have a form with a text box. I want the CTRL to display the Max number from a table.
Im building an expression but cant get the syntax right
=max(<<expression>><<expr>>[TUNNEL INFO 100]![CD16]
Thanks in advance
I have a form with a text box. I want the CTRL to display the Max number from a table.
Im building an expression but cant get the syntax right
=max(<<expression>><<expr>>[TUNNEL INFO 100]![CD16]
Thanks in advance
Hi -
You want to use the DMax function, something like
=DMax("FieldName","TableName","Criteria")
Post more details of what you want to do if you have trouble getting the syntax right.
John
The DMax() function can return the max value from table. If you want the maximum value in the form's dataset, use Max().
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.