display purchase qty, sales qty and item stock from 3 diff tables

i am using msaccess and crystal report

i have 3 tables as below,

item_table (item_id, itemname, stock)

purchase_table(item_id,itemname,Pur_qty,pur_date)

sales_table(item_id,itemname,sal_qty,sal_date)

in my report i want to show the fallowing

itemname pur_qty sal_qty Stock

apple 30 10 20

mango 20 5 15

• Filed under: stock [Edit Tags]
• | Post Points: 5