<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="MSHTML 11.00.9600.19081">
<style id="owaParaStyle">P {
MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px
}
</style>
</head>
<body fPStyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<div>
<div> I have a question. How do I get the greatest number in a certain field out of all the records.
<br>
</div>
<div>Example: I want pull the 4999 out of all the records to display in field or report.<br>
</div>
<div><br>
</div>
<div>rec# - Field Value</div>
<div>1. - 1999</div>
<div>2. - 4999</div>
<div>3. - 3999</div>
<div>4. - 2999</div>
<div>5. - 4999</div>
<div>6 - 3999<br>
</div>
<div><br>
</div>
<div>Thanks,</div>
<p> </p>
<div style="FONT-SIZE: 13px; FONT-FAMILY: Tahoma">
<div class="BodyFragment"><font size="2"><span style="FONT-SIZE: 10pt">
<div class="PlainText">Michael Thompson, Senior Network Analyst<br>
</div>
</span></font></div>
</div>
</div>
</div>
</body>
</html>