Search results

Round([Price1]*1.35;0) The ; produces an error, invalid syntax. I think there is a setting within the database that is causing the error and not the expression Round([Price1]*1.35,0)

I am trying to calculate a sell price in a query based on the following expression round([price1]*1.35,0) produces error message "compile error. in query expression 'Round([price1]*1.35,0) Used the same expression in a fresh database and it works perfectly. What am I doing wrong?