CODEWITHSUNDEEP
ms-access
Roger
Roger

Reputation:

target search in MS Access

In MS Excel there is a tool for an iterative calculation of one cell given a condition in an other connected cell (target search is my obvisoly very poor translation from Swedish). I now want to do this whatever-it-is-called in MS Access. Any hint or at least a correct English term would be of great help.

Upvotes: 0

Views: 230

Answers (2)

Philippe Grondier
Philippe Grondier

Reputation: 11138

Well, my advice is not to try to do that in Access! Let Excel do the Excel stuff (such as dealing with this 'Goal seek' algorythm), and let Access do the Access stuff: tables, views, relations, queries, data integrity, foreign keys, etc. And if your data is under Access, have it exported to Excel first!

Upvotes: 2

Roger
Roger

Reputation:

target search is called goal seek Excel

Upvotes: 2

Related Questions