Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
goal seek formula
- Thread starter budich
- Start date
MichaelRed
Programmer
To the best of my understanding, this is not available in Ms. Access. It may be part of an excell library which could be included in Ms. Access, however you would need to have a FULL undestanding of the function to apply it.
I would suggest that you instantiate the resolver function in an Excel worksheet, with all of the Arguments as NAMED RANGES. Then, you could export each data set from Ms. Access to the appropiate named range, recalc the sheet and read in the value(s) from the calculation.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
I would suggest that you instantiate the resolver function in an Excel worksheet, with all of the Arguments as NAMED RANGES. Then, you could export each data set from Ms. Access to the appropiate named range, recalc the sheet and read in the value(s) from the calculation.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
- Thread starter
- #3
Thanks Michael,
yes, I think so. We cannot find the goal seek formula in access.
In your suggestion, Is your idea try to link Access with excel? I am not clearly undertand.
Is it another way to solve the problem or with a function that I can put in a column in query.
Let's see my problem directly, (this is gross up salary case)
I have logic programming as :
start
assume tax (=x)
input take home pay (example = 5000)
so gross pay (=5000+x= Y)
Reduction coef of tax = 0.05 * Y
Reduction coef of tax (conditional) say = 100
Taxable salary = Y-(0.05*Y)-100 = Z
Tax (conditional depend on the range) =
say = 10 % so x = 10 % * Z
Is x same as x assumed above ? If not assume another x value until x = x assumed.
thank you
regards
Budi
input
yes, I think so. We cannot find the goal seek formula in access.
In your suggestion, Is your idea try to link Access with excel? I am not clearly undertand.
Is it another way to solve the problem or with a function that I can put in a column in query.
Let's see my problem directly, (this is gross up salary case)
I have logic programming as :
start
assume tax (=x)
input take home pay (example = 5000)
so gross pay (=5000+x= Y)
Reduction coef of tax = 0.05 * Y
Reduction coef of tax (conditional) say = 100
Taxable salary = Y-(0.05*Y)-100 = Z
Tax (conditional depend on the range) =
say = 10 % so x = 10 % * Z
Is x same as x assumed above ? If not assume another x value until x = x assumed.
thank you
regards
Budi
input
MichaelRed
Programmer
Both Excel and Access are OLE clients/providers. So, you set up your problem on a specific Excel workbook using NAMED ranges for the various elements. From Ms. Access, you can "Open" the Excel workbook and fill the named ranges with information, have excel 'recalc' the worksheet(s) and retrieve the values from the named ranges. this is NOT an area I am familiar with, how ever it is a common approach. I would suggest that you search the Ms. Access Forums for Excell, and post an additional question in this forum specifically referencing Excel and automation. Perhaps "Need help with MS Access and Excel Automation"
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question