By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,335 Members | 2,218 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,335 IT Pros & Developers. It's quick & easy.

"The expression you entered is too complex" error message how to fix this problem

P: 1
IIf([Medichine]="Clearing Nut","2,080/=",IIf([Medichine]="Garcinia","2,240/=",IIf([Medichine]="Ganoderma","3,350/=",IIf([Medichine]="Moringa","1,370/=",IIf([Medichine]="Nut Grass","1,740/=",IIf([Medichine]="Spirulina","2,610/=",IIf([Medichine]="Pumkin Seeds","4,110/=",IIf([Medichine]="Withania","3,480/=",IIf([Medichine]="Breast Enhasing Cream","1,370/=",IIf([Medichine]="Breast Reducing Cream","1,370/=",IIf([Medichine]="Inginee Milk","1,370/=",IIf([Medichine]="Horse Gram Curry","610/=",IIf([Medichine]="Rishi Oil","750/=",IIf([Medichine]="Quantum Pendant","4,510/=",IIf([Medichine]="Spirulina Face Pack","1,570/=",IIf([Medichine]="Hand Wash","205/=","0"))))))))))))))))
Oct 27 '18 #1
Share this Question
Share on Google+
2 Replies


Nauticalgent
P: 92
As the message says, you are trying to do too much at one time. Try breaking down the query into smaller queries. This will give you smaller, more definitive Record Sets to work with when you make your “master query”

Allen Browne has an excellant article on this topic.

You can also take a look at this thread:

https://bytes.com/topic/access/answe...ng-too-complex
Oct 28 '18 #2

twinnyfo
Expert Mod 2.5K+
P: 3,284
rajeeskhan,

It looks to me more like you should have a Table with all your items and values in it, then you just look up the value based upon the item:

tblMedechineItems

Expand|Select|Wrap|Line Numbers
  1. ItemName               ItemValue
  2. Clearing Nut           2080
  3. Garcinia               2240
  4. Ganoderma              3350
  5. Moringa                1370
  6. Nut Grass              1740
  7. Spirulina              2610
  8. Pumkin Seeds           4110
  9. Withania               3480
  10. Breast Enhasing Cream  1370
  11. Breast Reducing Cream  1370
  12. Inginee Milk           1370
  13. Horse Gram Curry       610
  14. Rishi Oil              750
  15. Quantum Pendant        4510
  16. Spirulina Face Pack    1570
  17. Hand Wash              205
Oct 28 '18 #3

Post your reply

Sign in to post your reply or Sign up for a free account.