I am printing inventory report.
job_code style ship_date
job_acc_code(job_code + 3 digit code)
codetype typefactor receivedQty issuedQty
I'm issuing this query to print the inventory
select job_acc_code,codetype,typefactor,sum(receivedqty-issuedqty) from inventory where (receivedqty>issuedqty) group by job_acc_code,codetype,typefactor
This is working fine.
But i need style from jobdetails table also corresponding to job_acc_code(6 digit job_code + 3 digit accessory code).
How can i get????
I'm using MSAccess.