Hi All,
Thank for stepping by. I am new to Access and I would really use your help. I am trying to develop management system. The problem I encountered is as follow:
1. I have two fields in table ´Category´ has following possible values ´New´ or ´Renew´ and ´Priority´ has ´Low´, ´Medium´, ´High´.
2. I need third field Capacity.
3. The Capacity should be calculated based on Category and Priority i.e user selects New + Low then Capacity should be 1.
I tried switch and if statement but I got constant errors. All help much appreciated. Please let me know in case any questions.