Help me for my problem please

[aidil]

Hi All,

Here's my table structure

Table 1: STM (Store Master)
             STR_CODE 
             Desc
             part_number

Table 2 : MRC(Master Received)
             Ref_No 
             Rec_date

Table 3 : DRC (Detail Recived)
             Ref_no
             PO_No
             STR_CODE
             qty
              price

Table 4: MPO (Master PO)
             PO_No
             PO_Date

 Table 5: OPO (OUT Standing PO)
             STR_CODE 
             PO_No
             PO_date
             PO_QTY
             PP_date
             PP_No


how to the query format, if i want to create the report, below:

No.  REF_NO   REC_DATE  PO_NO  PO_DATE    Item   STR_CODE   DESC  PART_NUMBER   PP_NO  
 PP_DATE  RCV.QTY
___  _______   __________  ______   ________    ____   __________   _____  
______________  _______   ________   ________

thanks before,