Reports not displaying all the data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok. I want to produce a report based on the following query:-
Qty_InQuery Qty_OutQuery
Qty_In Qty_Out Total:[SumOfQty_In]-[SumOfQty_Out]
Group By Group By Expression

When I view the Query and by the same token the report I get all the data
returned only if I have inputs for qty in and qty out. I get no output in the
report if I do not have input for qty out: ie if qty out is zero. I have a
feeling I am missing something really obvious but I just cannot see it. Is
the formula correct if it is what could I be doing wrong?
Thank you Mart012
 
Very well Karl here is the SQL Code;
SELECT tbl_Stock_List.Stock_ID, tbl_Stock_List.Description,
tbl_Stock_List.[Size(mm)], tbl_Stock_List.gsm,
Qty_Received_Qry.SumOfQty_Received, Qty_Issued_qry.SumOfQty_Issued,
[SumOfQty_Received]-[SumOfQty_Issued] AS [Stock Remaining]
FROM (((tbl_Stock_List INNER JOIN Qty_Issued_qry ON tbl_Stock_List.Stock_ID
= Qty_Issued_qry.Stock_ID) INNER JOIN Qty_Received_Qry ON
tbl_Stock_List.Stock_ID = Qty_Received_Qry.Stock_ID) INNER JOIN
tbl_Job_Issues ON tbl_Stock_List.Stock_ID = tbl_Job_Issues.Stock_ID) INNER
JOIN tbl_Goods_In ON tbl_Stock_List.Stock_ID = tbl_Goods_In.Stock_ID
GROUP BY tbl_Stock_List.Stock_ID, tbl_Stock_List.Description,
tbl_Stock_List.[Size(mm)], tbl_Stock_List.gsm,
Qty_Received_Qry.SumOfQty_Received, Qty_Issued_qry.SumOfQty_Issued;
I hope it makes sense to you because it confuses the hell out of me. I'm a
newbie.


KARL DEWEY said:
Please post your SQL statement.

Mart012 said:
Ok. I want to produce a report based on the following query:-
Qty_InQuery Qty_OutQuery
Qty_In Qty_Out Total:[SumOfQty_In]-[SumOfQty_Out]
Group By Group By Expression

When I view the Query and by the same token the report I get all the data
returned only if I have inputs for qty in and qty out. I get no output in the
report if I do not have input for qty out: ie if qty out is zero. I have a
feeling I am missing something really obvious but I just cannot see it. Is
the formula correct if it is what could I be doing wrong?
Thank you Mart012
Click to expand...
Click to expand...
 
Back
Top