<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=313424121-14102003><FONT face=Arial color=#0000ff size=2>How
many records are we talking about, maximum? There is an easy way to do
this in JET if you don't have too many field to deal with. (It would need to be
under the max number of fields you can have in a query)</FONT></SPAN></DIV>
<DIV><SPAN class=313424121-14102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=313424121-14102003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Lonnie Johnson
[mailto:prodevmg@yahoo.com]<BR><B>Sent:</B> Tuesday, October 14, 2003 12:31
PM<BR><B>To:</B> 'MS-ACCESS-L@lists.missouri.edu'; AccessDevelopers; AccessD
solving'<BR><B>Subject:</B> [AccessD] Math Problem<BR><BR></FONT></DIV><LABEL
id=HbSession SessionId="3081583070"></LABEL>
<DIV>This is one for the math guys who code. I have a situation where I need
to take a field in a group of records and see if any combination of the values
in the field equal
zero.<BR><BR>Example:<BR><BR>MyField<BR> 5<BR> -2<BR> 7<BR> -3<BR> 6<BR><BR>This
group of records would have a combination that equals zero (5, -2, -3). I hope
someone has something. </DIV><BR><BR>
<DIV>
<DIV>
<P align=center><STRONG>Lonnie Johnson<BR></STRONG><STRONG>ProDev</STRONG>,
Professional Development of MS Access Databases<BR>Visit me at ==> <A
href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR><A
href="http://www.galaxymall.com/software/PRODEV"><BR></A><BR> </P></DIV></DIV>
<P>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext%2Csec%3Amail">The
New Yahoo! Shopping</A> - with improved product
search</BLOCKQUOTE></BODY></HTML>