compile error when round

Comet

New member
Local time
Today, 01:03
Joined
May 29, 2012
Messages
2
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?
 
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)
 

Users who are viewing this thread

Back
Top Bottom