I have the following Text Box where its Control source with code "=IIf([T020]<>0,Sum([PrevBalance147]),0)"
Where [T020] Text Box with "=Count(*)" in the footer and PrevBalance147 is an integer From the datasource of the report.
When this Control source is created on Computer A and Opened it works fine on both Computers when opening the report.
But Computer B Can't Create the same Control source or edit the existing Control source without receiving the error:
"The expression you have entered contains invalid syntax."
"You may have entered an operand without an operator."
I have tried multiple ways of Criteria for this Control source but receive errors on Computer B That Computer A Doesn't Receive.
Don't know if this has something to do with computer settings that have been changed.
Both Computers have been freshly reinstalled with Windows 10 and Microsoft Access 2016 32bit
Ruben