Yeah!
that worked!!!! but here is one more question for a different report... the same problem is occuring in a number column. if the guys don't have sales for an account, that account isn't showing up on the report, it is just skipping it.. i think it is the same problem, but i am not sure where to fix it.. the columns that are sometimes zeros are ar_weight and ar_sales.
here is the sql code.....
SELECT ARHIMAST.AR_MM, ARHIMAST.AR_YY, ARHITRAN.AR_WEIGHT, ARHITRAN.AR_SALES, ARHITRAN.AR_PROD, INMAST.IN_PACK, INMAST.IN_DESC, INMAST.IN_BRAND, INMAST.IN_ORIGIN, [ar_sales]-[complete cost] AS [total profit], [ar_weight]*([ar_mcost]+[ar_freunit]+[ar_rebunit]+[ar_comunit]) AS [complete cost], ARHITRAN.AR_DOCNO, ARMAST.AR_ADDR1, ARMAST.AR_ADDR2, ARMAST.AR_ADDR3, ARMAST.AR_CITY, ARMAST.AR_STATE, ARMAST.AR_ZIP, ARMAST.AR_BUYGRP, ARMAST.AR_SLSMAN, ARMAST.AR_TERMS, ARMAST.AR_PPHONE, ARMAST.AR_PFAX, ARMAST.AR_CREDIT, ARMAST.AR_PCONT1, ARMAST.AR_PCONT2, ARMAST.AR_DPHONE, ARMAST.AR_NAME, ARMAST.AR_CUST
FROM ((INMAST INNER JOIN ARHITRAN ON INMAST.IN_NO = ARHITRAN.AR_PROD) INNER JOIN ARHIMAST ON (ARHITRAN.AR_DOCNO = ARHIMAST.AR_DOCNO) AND (ARHITRAN.AR_CUST = ARHIMAST.AR_CUST)) INNER JOIN ARMAST ON ARHIMAST.AR_CUST = ARMAST.AR_CUST
WHERE (((ARHIMAST.AR_MM)="07") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 1 And 313)) OR (((ARHIMAST.AR_MM)="07") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 315 And 318)) OR (((ARHIMAST.AR_MM)="07") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 320 And 999)) OR (((ARHIMAST.AR_MM)="08") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 1 And 313)) OR (((ARHIMAST.AR_MM)="08") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 315 And 318)) OR (((ARHIMAST.AR_MM)="08") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 320 And 999)) OR (((ARHIMAST.AR_MM)="09") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 1 And 313)) OR (((ARHIMAST.AR_MM)="09") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 315 And 318)) OR (((ARHIMAST.AR_MM)="09") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 320 And 999)) OR (((ARHIMAST.AR_MM)="10") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 1 And 313)) OR (((ARHIMAST.AR_MM)="10") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 315 And 318)) OR (((ARHIMAST.AR_MM)="10") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 320 And 999)) OR (((ARHIMAST.AR_MM)="11") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 1 And 313)) OR (((ARHIMAST.AR_MM)="11") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 315 And 318)) OR (((ARHIMAST.AR_MM)="11") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 320 And 999)) OR (((ARHIMAST.AR_MM)="12") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 1 And 313)) OR (((ARHIMAST.AR_MM)="12") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 315 And 318)) OR (((ARHIMAST.AR_MM)="12") AND ((ARHIMAST.AR_YY)="04") AND ((ARHITRAN.AR_PROD) Between 320 And 999)) OR (((ARHIMAST.AR_MM)="01") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 1 And 313)) OR (((ARHIMAST.AR_MM)="01") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 315 And 318)) OR (((ARHIMAST.AR_MM)="01") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 320 And 999)) OR (((ARHIMAST.AR_MM)="02") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 1 And 313)) OR (((ARHIMAST.AR_MM)="02") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 315 And 318)) OR (((ARHIMAST.AR_MM)="02") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 320 And 999)) OR (((ARHIMAST.AR_MM)="03") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 1 And 313)) OR (((ARHIMAST.AR_MM)="03") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 315 And 318)) OR (((ARHIMAST.AR_MM)="03") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 320 And 999)) OR (((ARHIMAST.AR_MM)="04") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 1 And 313)) OR (((ARHIMAST.AR_MM)="04") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 315 And 318)) OR (((ARHIMAST.AR_MM)="04") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 320 And 999)) OR (((ARHIMAST.AR_MM)="05") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 1 And 313)) OR (((ARHIMAST.AR_MM)="05") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 315 And 318)) OR (((ARHIMAST.AR_MM)="05") AND ((ARHIMAST.AR_YY)="05") AND ((ARHITRAN.AR_PROD) Between 320 And 999));
thanks sooooo much for all your help...
schmals
![[ponytails] [ponytails] [ponytails]](/data/assets/smilies/ponytails.gif)