Error in Query, The expression you entered contains invalid syntax

[Robert2150]

I have a query where I am calculating the ITEM AGE of an item.



ITEM AGE: DateDiff("yyyy",[SSMA$SQFT/LF ITEMS]“DATEACQUIRED”,Now()) by using an existing field in the table:
The field used in the calculation is "DATE ACQUIRED"
The table name is SSMA$SQFT/LF ITEMS

I keep getting the error that I may have entered an operand without and operator.

I have worked on this for quite a while to no avail.

What obvious thing am I missing?

Thank you for your help in advance.

[ssanfu]

Your syntax is wrong,

Try

ITEM AGE: DateDiff("yyyy", DATEACQUIRED, Now())

The table needs to be in the query for this to work.


BTW, a table name of "SSMA$SQFT/LF ITEMS" is a horrible name!
You have a space, the dollar sign and a slash in the name.

Good naming rules to follow:
Use only letters and numbers (exception is the underscore) for object names.
Do notuse spaces, punctuation or special characters in object names.

Object names are field, query, form and report names.