Math / Function Question

  • Thread starter Thread starter David Smith
  • Start date Start date
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
 
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
(e-mail address removed)
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
 
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.
 
Back
Top