<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Hi Richard:<BR>
<BR>
; I would try to get IA_DIST_CHECK out of the ACCESS statement<BR>
; My guess is you have duplicate check numbers. Thus your scratch file<BR>
; will contain the cross product of duplicate check numbers in DUPCHK<BR>
; and IA_DIST_CHECK. <BR>
;<BR> <BR> ACCESS *DUPCHK <BR> OUTPUT IA_DIST_CHECK UPDATE ALIAS IA_DIST_CHECK_UPD &<BR> VIA CHECK_# &<BR>
USING CHECK_# OF IA_DIST_CHECK &<BR>
ON ERRORSREPORT ; just in case a check is missing<BR> ITEM CHECK_# OF IA_DIST_CHECK_UPD FINAL & <BR> "9" + CHECK_# OF IA_DIST_CHECK[2:8]<BR>
<BR>
Regards,<BR>
Peter Bateman<BR>
<BR><BR><br /><hr />Internet Explorer 8 makes surfing easier. <a href='http://go.microsoft.com/?linkid=9655264' target='_new'>Get it now! </a></body>
</html>