Here is the code that I was trying.
This part of the code works.
But as soon as I add Value from the first Resident table to be part of an expression I get an error that it can't find that field.
Num(((Num([On Scene Time]) - Num([Pickup Date/Time]))*60*24),'###.00') as Response_Time
Drop Table Final_Metrics, Run_Data;
I actually came up with a solution that works.
I just added another resident load at the end of the MergedTable and then did the calculation that I needed there. I don't know if that is the best way to do it. But it worked for me.
I don't have a massive amount of data to deal with. So I don't have to be too concerned about being efficient.