Windows 7 64bit 
Access 2007
Hi Guys...need help with another set of query...TIA!
***There should be a prompt window to enter the Week (i.e. 20/21/22)
***Data should only reflect those with Status = "Done"
For Week 20, this is how the table should look like.
PIC MCC/IPC C6, Customer Form, CMRT CoC, IPC C4 Wendy 1 Amy 1 2
For Week 21, this is how the table should look like.
PIC MCC/IPC C6, Customer Form, CMRT CoC, IPC C4 Wendy 4 1 Amy 2 1 Samantha 4
For Week 22, this is how the table should look like.
PIC MCC/IPC C6, Customer Form, CMRT CoC, IPC C4 Wendy 1 Amy 2 2 Samantha 1 1
Database looks something like this...
PIC WK Supplier Status Quality Wendy 20 ABC Done MCC/IPC C6 Amy 20 ABC Done MCC/IPC C6 Amy 20 Littelfuse Done CoC Amy 20 Littelfuse Done IPC C4 Wendy 21 ABC Done CMRT Wendy 21 Maxim Done IPC C4 Samantha 21 BOURNS Done MCC/IPC C6 Wendy 21 NXP Done MCC/IPC C6 Wendy 21 Analog Done MCC/IPC C6 Wendy 21 TYCO Done MCC/IPC C6 Wendy 22 Keysight Done MCC/IPC C6 Amy 21 Littelfuse Done MCC/IPC C6 Amy 21 Nichicon Done MCC/IPC C6 Samantha 22 BOURNS Done CMRT Samantha 22 BOURNS Done IPC C4 Samantha 21 BOURNS Done Customer Form Samantha 21 ABC Done CMRT Samantha 21 NXP Done CMRT Amy 21 Panasonic Done IPC C4 Amy 22 Vishay Done IPC C4 Amy 22 Vishay Done IPC C4 Amy 22 MURATA Done MCC/IPC C6 Amy 22 MURATA Done MCC/IPC C6
Reply With Quote
