J G
asked on
Error Sorting a calculated table field control
When I try to sort on a calculated table field form control in data sheet view, I get the following error:
Syntax error (missing operator) in query expression 'All'.
When I hit ok on the dialogue box, I am still able to sort.
Below is the expression for the calculated table field called 'All'. the results yielded by the values are correct, so I am not sure where the missing syntax is.
IIf([tbl_Item].[WES]+[tbl_ Item].[CAP ]+[tbl_Ite m].[PAC]+[ tbl_Item]. [HMB]+[tbl _Item].[EV G]=([tbl_I tem].[WES] *5),[tbl_I tem].[WES] ,([tbl_Ite m].[WES]+[ tbl_Item]. [CAP]+[tbl _Item].[PA C]+[tbl_It em].[HMB]+ [tbl_Item] .[EVG])/5)
Syntax error (missing operator) in query expression 'All'.
When I hit ok on the dialogue box, I am still able to sort.
Below is the expression for the calculated table field called 'All'. the results yielded by the values are correct, so I am not sure where the missing syntax is.
IIf([tbl_Item].[WES]+[tbl_
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.