DMax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to set a default for a text field on my form to show Max number.

I tried something like DMax([my field]) to find maximum but it doesn't work.
Why?

What am I doing wrong?

Thank you.
Lana
 
Oh, sorry guys - I am so stupid!

I should have figured it out before bothering you.
It should have been:
=DMax("[My field]","[my table]")

Now it works perfectly!

Sorry! :)
Lana
 
No, the [ ] are not needed around the field for a domain function's first
argument.

--

Ken Snell
<MS ACCESS MVP>

Bill Mitchell said:
actually its dmax("[myfield]","mytable") to be accurate.

Lana said:
Oh, sorry guys - I am so stupid!

I should have figured it out before bothering you.
It should have been:
=DMax("[My field]","[my table]")

Now it works perfectly!

Sorry! :)
Lana
Click to expand...
Click to expand...
 
Back
Top