Using Sub-report to get desired results

I have 2 tables I would like to query results from and generate a report.

table_sales contains line item sales data
table_tracking contains ups tracking info

From table_sales I make 2 querries.

query_sales_summary gives me order summary info.
order_num, order_date, ship_name, sub_total, tax_amt, frt_amt

query_sales_details gives me order detail info.
order_num, item_num, item_desc, item_uom, item_price

From table_tracking I make one query.

query_tracking gives me tracking detail.
order_num, tracking_num, status, signature

What I want to produce is a report that renders information grouped by
order_num sorted by order_date.

I would like to see all the summary data grouped together in the order_num
Header.

The trick for me is that an order_num can have multiple tracking_num's.

This results from an order_num can be multiple packages that when shipped
via UPS are assigned a unique tracking_num per package.

I cannot figure out how to accomplish this at all.

Any help would be greatly appreciated.

thanks

Hello,
I had a similar problem with invoices and found that a
Union Query worked quite well. You have to use a little
SQL, but the Access help has good guidance. You can get
to an SQL window by creating a new query in the design
view and then selecting SQL from the View menu.

-----Original Message-----
I have 2 tables I would like to query results from and
generate a report.