I'm building an access query, in it one of the fields is called
[Space Available (cm)]
I'm trying to add a divided by 6 field, so I've inserted a field in design view in the query, it looks like this:
Field: Expr1: SectioalSpaceAvailable
Table:
Sort:
Show:
Criteria: =[Space Available (cm)] / 6
or:
When I go to switch into Datasheet View I get the error "Undeined function 'SectionalSpaceAvailable' in expression but all the expression examples i see on the net have =[fieldname] / X as how to write such an expression, what am i missing here?
[Space Available (cm)]
I'm trying to add a divided by 6 field, so I've inserted a field in design view in the query, it looks like this:
Field: Expr1: SectioalSpaceAvailable
Table:
Sort:
Show:
Criteria: =[Space Available (cm)] / 6
or:
When I go to switch into Datasheet View I get the error "Undeined function 'SectionalSpaceAvailable' in expression but all the expression examples i see on the net have =[fieldname] / X as how to write such an expression, what am i missing here?