I'm trying to convert an Excel formula to Access and use it as an expression in a query. The Excel formula is:
In the Access form/subform...
J11 = txtSplits on the subform
M5 = txtSplitsBenchmark on the main form
I11 = txtNetCWT on the subform
M6 = txtDisSchd3 on the main form
K11 = txtDamage on the subform
M7 = txtDamBenchmark on the main form
M8 = txtDisSchd4 on the main form
Can someone please help convert the Excel formula in a syntax I can use for an expression in query designer?