I need to put the Vendor Part number in this report - Anyone know which field it is?  
 
~Carie

 
SELECT  
BKICMSTR.BKIC_PROD_CODE,  
BKICMSTR.BKIC_PROD_DESC,  
BKICMSTR.BKIC_PROD_TYPE,  
BKICMSTR.BKIC_PROD_UM,  
BKICMSTR.BKIC_PROD_CAT,  
BKICMSTR.BKIC_PROD_UOH,  
BKAPVEND.BKAP_VENDNAME
FROM (BKICMSTR RIGHT JOIN BKSBVEND ON BKICMSTR.BKIC_PROD_CODE = BKSBVEND.BKSB_VEND_PROD)  
LEFT JOIN BKAPVEND ON BKSBVEND.BKSB_VEND_VEND = BKAPVEND.BKAP_VENDCODE;
 
If you setup this report on ms access you can "group" the vendors for each part.
 
Kelloggs