hello,

  I am printing inventory report.
Tables:
------
1. jobdetails:

   job_code style ship_date

2. inventory:

  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.

What do you mean: But i need style from jobdetails table

Brian

Yes,

  Style also to be displayed from jobdetails table. My report should display...

job_acc_code Style Codetype, typefactor balance

    In your SQL, you must join to the JobDetails table.