<!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.2800.1126" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=562125917-14102003><FONT face=Arial color=#0000ff
size=2>Lonnie,</FONT></SPAN></DIV>
<DIV><SPAN class=562125917-14102003><FONT face=Arial color=#0000ff size=2>I'm
just curious... why do you want to know this?</FONT></SPAN></DIV>
<DIV><SPAN class=562125917-14102003><FONT face=Arial color=#0000ff size=2>Is
there a finite number of field or is the field number
dynamic?</FONT></SPAN></DIV>
<DIV><SPAN class=562125917-14102003><FONT face=Arial color=#0000ff size=2>What
are you going to do with the answer?</FONT></SPAN></DIV>
<DIV><SPAN class=562125917-14102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=562125917-14102003><FONT face=Arial color=#0000ff
size=2>Jim</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>