Can you help me build the right IIf field in the query with the following conditions :
The field DDU consissts of :
To the above expression i must also add 0,001 if size = 205, etc according to the following table :
However Acces does not accept my query, obvioulsy i have errors :
DDU : [exworks]*2+0,4+0,01 + IIf([size = 205],0,001,[size = 60],001)
Will you help me ?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!