target search in MS Access

Question

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.

Answer 1

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!