The database calculates using data from 4 tables within the database

 

Adjustment

Issue

Return

Receive

 

The formula is (receivedqty)+(returnqty)+(adjqty)-(IssueQty)

 

The inventory Items are in the stockcode table

All tables contain the stock code and are linked by this field

 

My problem is that the report is not listing all inventory items when I insert a value from one of the 4 tables used in the calculations. I think the problem is centered around the fact that all stockcodes have not experienced adjustment, receive, return, or issue, so any stockcode not in these tables is excluded.

 

How do I get the report to continue to list all stockcodes from the stockcode table and list the values from the other tables?

 

Thans for your help!

 

 

 

 

 

I figured out the join issue Satuday afternoon.

I am now displaying the data, but still have a few issues. 

 

I need to sum the values for each stock code, and have written a simple formula to do so, but when I place this formula in the report I am getting blank fields.  

 

The other issue is that is there are multiple entries for a stockcode in a table (ie.. the part has been issued on more than on occasion) I am getting a line in the report for each transaction.

 

Thanks for the help

 

Kevin