ExpressMan1
asked on
IIf query syntax in Make table query
I am getting a error with the following make table query,
BaseCost: IIf([Weight]<100,[Cost]),I If([Weight ]>100,[Cos t]*[Weight ])
Error: "contains invalid syntax or you need to enclose your text data in quotes"
If i try the first part only it works, BaseCost: IIf([Weight]<100,[Cost])
BaseCost: IIf([Weight]<100,[Cost]),I
Error: "contains invalid syntax or you need to enclose your text data in quotes"
If i try the first part only it works, BaseCost: IIf([Weight]<100,[Cost])
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER