Syntax error in query expression

[That_Guy]

HI Guys, first post of many to come I am sure. My role at work is Access heavy and I have very limited experience in it. I am impressed with Access, it is a very powerful tool. As always, with power comes complexity. This one I am sure is easy for you though... I just can't find the error. Please help. This is in a Query, this expression is in the 'Field:' This is the pop up I am receiving.



Syntax error in query expression '[DATA MANSI].[Round([DATA MANSI]].[Jul,2)]

This is what the data in DATA MANSI Table under Jul colum are numbers with 2 decimal spots, ie; 710.54.

How can I fix this? Thanks

[pbaldy]

You only want the square brackets around the table name. They are required because of the inadvisable space.

[JoeM]

The syntax is all messed up.

The format of the Round function is:
ROUND(fieldname,precision)

So you just want to drop the field name in the middle of it, i.e.
Expr1: ROUND([DATA MANSI].[Jul],2)

[That_Guy]

The syntax is all messed up.

The format of the Round function is:
ROUND(fieldname,precision)

So you just want to drop the field name in the middle of it, i.e.
Expr1: ROUND([DATA MANSI].[Jul],2)

Worked like a charm. Thanks! Probably going to have another question in 30 minutes. HA