Hi friends,

  I have two queries(qry_order, qry_receive).
structure is

qry_order

jobCode typefactor codetype totQtyOrdered

qry_receive

jobCode typefactor codetype totQtyReceived


I want a query to select jobCode,typefactor,codetype,totQtyOrdered,totQtyRe ceived,totQtyOrdered-totQtyReceived as balance from these two queries.

I tried, left join, union, join but no result. Wat my aim is when i am receiving the material, i want to show the user Total quantity ordered for that job till now and total we received and balance to be received. If no qty is received only data from ordered table is shown.

Wat could be the query. Every response is highly appreciated.

This may teaching you how suck eggs, but I always set up my complex query use Query Design View, once working I just copy the SQL code that is automatically generated into my procedure.
HTH

Cheers Ray