Math / Function Question

D

David Smith

Hey Guys! This is David Smith, I work with Access 2000. I
have a
question for you.
If you have 5 variables with a given range for each
variable and a
condition that must be meet. Is there a V.B. function that
will exhaust
all possible combinations until the condition is meet or
all
possibilities have been tried? I have used nested " Do
until / Loop
until " statements before but the number always needed to
be bigger. In
this case variable 2 may need to go down but variable 4 go
up.

Thanks

David Smith
 
T

Tom

Hey David Smith! This is PC Datasheet, I work with Access97, 2000 and XP.

Look at Excel automation and using Solver.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
[email protected]
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
 
J

John Spencer (MVP)

The answer, as far as I know, is - There is no function in Access to do this.
You have to write your own function or do this in EXCEL.
 
Top