Pretty complex, I guess. I put this in the query builder:
Code:
TEMP_NAME: ([INITIAL_ACTIVITY]*1000)*(Exp(-(0.693/[HALF_LIFE HOURS (Hours)])*(DateDiff("h",[INDUCTION_DATA]![RECEIVED_DATE],Date()))))
Which gave me this SQL:
Code:
SELECT INDUCTION_DATA.*, DateDiff("d",[INDUCTION_DATA]![REFERENCE_DATE],Date()) AS [Elapsed(days)], DateDiff("h",[INDUCTION_DATA]![REFERENCE_DATE],Date()) AS [Elapsed(hours)], ([INITIAL_ACTIVITY]*1000)*(Exp(-(0.693/[HALF_LIFE HOURS (Hours)])*(DateDiff("h",[INDUCTION_DATA]![REFERENCE_DATE],Date())))) AS TEMP_NAME
FROM INDUCTION_DATA;
And it runs fine