Largest Value + 1

How do I search for the single largest value (numeric) and add a value of 1? I've been reading some of the posts and saw something about DMAX() and Largest but don't have a clue as to how to use them.

Sorry if this is a second post, but I can't find where my first one went. You can tell that I need a basic response......

Thanks.

On my website, see sig below, is a small sample database called
"AutonumberProblem.mdb" which illustrates how to use DMax in just the way
you want.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Nancy" wrote in message
...
How do I search for the single largest value (numeric) and add a value of
1? I've been reading some of the posts and saw something about DMAX() and
Largest but don't have a clue as to how to use them.

Sorry if this is a second post, but I can't find where my first one went.
You can tell that I need a basic response......

Thanks.

Thanks. I'll check it out!

I tried this but am getting #Error in the new field.

Make sure everything is spelled correctly. This will often cause the #Error

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Nancy" wrote in message
...
I tried this but am getting #Error in the new field.