Any way to use "Goal Seek" in Access?

[Guest_imported]

Excel has a great feature that I use frequently called Goal Seek. It is basically a what if calculation that let's me back into a certain percentage. By that I mean, I can tell excel to come up with a 20% discount calculation in my medical reimbursement model by changing the value of the payment amount cell. Is there anyway you can do this in access?

 

[JPeters]

If you can figure out what formula the Goal Seek function runs (whatever it is) you can probably mimic it using VBA in Access.

-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------

 

[Guest_imported]

Thanks for the message. Sounds like I need to learn VBA!

 

[JPeters]

Well, if you just post what you think the formula does, someone here can probably write the code for you and tell you how to implement it to save you the trouble.

-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------