two group details in report

A

Azad, DH, BD

Suppose I have 2 tables
Transfer Receive
MTO-- ITem name - -- qty MTi-- ITem name - -- qty
453 -- Cement ----- 50 253 -- Cement -----
500
324-- Rod ----------500 34-- Sand
----------500
213 -- Cement ---- 20 211 -- Cement ---- 20

I'd like to show both transfer & Receive in a single report by two group
header Transfer & Receive as bellow"

Transfer Receive
MTO-- ITem name - -- qty MTi-- ITem name - -- qty
453 -- Cement ----- 50 253 -- Cement -----
500
324-- Rod ----------500 34-- Sand
----------500
213 -- Cement ---- 20 211 -- Cement ---- 20
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need help with data from different tables in detail lines 2
Group header makes report too long 4
Report detail col heading problems 2
Mail Merge with Access Report (with grouping levels) 2
Mail Merge with Access Report (grouping levels equivalent) 4
advice on better report design - opening/closing balance 1
Report Grouping Criteria 4
Report Group Criteria 0

Top