I want to design the inventory query, it have three table that first is distrubution of gift certicifate table, second is sale table and the last table is certicifate ID table.
Gift Certicifate ID Table
ID Certicifate Price 1 Gift Certificate $20 $20 2 Gift Certificate $50 $50
To distribute the gift certicifate from Office to Customer Service
date sale ID Certificate ID Begining No Last No. count 07/15/12 1 Gift Certificate $20 1 10 10 2 Gift Certificate $50 101 110 10
I have 10 Gift Certificate $20 from No.1 to No. 10
If Sale is From No. 3 to No. 8 at gift Certificat $20.
How Can i Program this situation?
Certificate No. 1 2 3 4 5 6 7 8 9 10 Sale No. (Gift Certificate $20, 07/19/12) 3 4 5 6 7 8 1 2 3 4 5 6 7 7 9 10 1 2 3 4 5 6 7 8 9 10
Inventory of customer Service Query design
Estimated result.
Date Certicifate ID Beginnig No Last No Count 07/21/12 Gift Certificate $20 1 2 2 Gift Certificate $20 9 10 2
Only red case is not working---
I use the "IIf" cord, every case is soved, but red letter case is not working and error.
I need help.
Damien Choi