[AccessD] Math Problem

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)
 
Drew

-----Original Message-----
From: Lonnie Johnson [mailto:prodevmg at yahoo.com]
Sent: Tuesday, October 14, 2003 12:31 PM
To: 'MS-ACCESS-L at lists.missouri.edu'; AccessDevelopers; AccessD solving'
Subject: [AccessD] Math Problem


 
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.

Example:

MyField
   5
  -2
   7
  -3
   6

This group of records would have a combination that equals zero (5, -2, -3).
I hope someone has something. 



Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us <http://www.prodev.us/> 


 <http://www.galaxymall.com/software/PRODEV> 

 



  _____  

Do you Yahoo!?
The
<http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext
%2Csec%3Amail> New Yahoo! Shopping - with improved product search

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031014/e114d2c4/attachment-0001.html>