-
Group Report
I have 2 tables in ms access
1] Item_batch_mst (fields) - item_cd,item_crnt_qty
note : - these table is having multiple records with same item_cd
2] item_mst (fields) - item_cd, item_descriptin, item_level
note haing single record for item_cd
i wanted have rpt with item_batch_mst.item_cd,item_mst.item_description,
item_mst.item_level, sum(item_batch_mst.crnt_qty)
where sum(item_batch_mst.crnt_qty) < item_mst_item_level
and item_batch_mst.item_cd=item_mst.item_cd
i want all records from item_batch_mst by grouping on item_cd and sum of crnt_qty whose value is less then item_levle(item_mst)