I have a “Source” base and a “Second” base. I want to do calculations in the “Second” base using data from the “Source”.
The problem is that the data comes from a lookup in a table of the “Source” base. This seems to come forward as text not as a number so I get errors in response to the calculation.
Bringing the data forward from the 2 original tables in the “Source” base doesn’t work since they need to be synchronised into one record.
I need to do this because I do not want to do this work in the original database - which is already too complicated. I also want to keep it away from other users.