Link to home
Start Free TrialLog in
Avatar of J G
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_Item].[PAC]+[tbl_Item].[HMB]+[tbl_Item].[EVG]=([tbl_Item].[WES]*5),[tbl_Item].[WES],([tbl_Item].[WES]+[tbl_Item].[CAP]+[tbl_Item].[PAC]+[tbl_Item].[HMB]+[tbl_Item].[EVG])/5)
ASKER CERTIFIED SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial