Target Search in MS Access
MS Excel has a tool to iteratively calculate one cell with a condition in another linked cell (target search is my obvisoly very bad translation from Swedish). Now I want to do it no matter what it called in MS Access. Any hint or at least a correct English term will be very helpful.
0
Roger
source
to share
2 answers
Well my advice is not to try to do this in Access! Let Excel do Excel stuff (for example, deals with this target lookup algorithm) and let Access do Access stuff: tables, views, relationships, queries, data integrity, foreign keys, etc. And if your data is in the Access section, export it to Excel first!
+2
source to share