"Solver" Function

[aervin5]

Does anyone know if there is a function in Access similar to the "Solver" function in Excel? I need to vary a calculation input until the calculation matches another number.

Can anyone help me with this?

Thanks!

 

[Summerwind]

I'm fairly sure that there is no such function. I've certainly not seen one.

As I see it you have two options: Shell out to Excel or write the function yourself

 

[gemma-the-husky]

you would probably have to code it in a button - probably not to hard
to do - just take a seed value, and keep modifying the seed until you get matching answers.

what exactly are you trying to solve - i'm no expert on it but i am sure there are ways of using the excel functions engine directly in access - so you may be able to fdo it that way