Mikethered
IS-IT--Management
In the context of a report I use expression builder to create an expression which includes a typical SQL reference to a column of a table. I explicitly select the table and the column. Expression builder puts this into the expression as
![column]
This is then rejected as bad syntax, which it is.
If I write the expression myself directly into the Properties data box as
table.column
it works fine.
Have I missed something, or is Access expression builder incapable of building an expression which refers to a column of a table?
This is then rejected as bad syntax, which it is.
If I write the expression myself directly into the Properties data box as
table.column
it works fine.
Have I missed something, or is Access expression builder incapable of building an expression which refers to a column of a table?
