I am wracking my brain here.
I need to formulate a function
that will search a database for several records that match alphabetic
criteria
created from a formula on the template,
then look at another field containing numeric info in those records
and return back to me the largest of those numeric values.

No such luck.

VLOOKUP returns the first one it sees (sorting is not an option in my case).
MAX doesn't look at criteria.
IF hasn't worked the way I had it.
DMAX doesn't work and you have to have the database open.

PLEASE HELP!!!!
I've already tried what's at the below post:

http://www.microsoft.com/communities...7-0284e231fa7e