Add Max value + .01 whole number

[CTOROCK]

I have a form and I am trying to get a button to add a new record with a +.01 to the Max whole value in the field. I have a function to find if there's a match and if so, add +.01. but I am trying to add another function to add a new record with a + 1.01 of the highest full number. If the greatest value was 344.03 it would result in 345.01. I think like :

CInt(SngMax) + 0.01

[the field is 2 decimal fixed]
but how can I get SngMax to be the Max whole value of the table?

Been stuck for a long time, any help is greatlly apreciated. Thanks in advance for any suggestions.

Eric

"The greatest risk, is not taking one."

 

[ZmrAbdulla]

Try DMax()

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[CTOROCK]

Beauty. Thanks, works like a charm. Needed a little refreshing. Thanks again!

"The greatest risk, is not taking one."