Hi all,
I'm very new to Access. I'm in desperate need of assistance.

My data:

Table 1
Vessel | Date | Supplier | Inbound Qty
Vessel A | 1/1/2012 | Supplier A | 2000
Vessel A | 1/1/2012 | Supplier B | 2500
Vessel A | 5/3/2012 | Supplier A | 3000

Table 2
Vessel | Date | Outbound Qty
Vessel A | 1/1/2012 | 4500
Vessel A | 5/3/2012 | 3000

How I want the query to look:
Vessel | Date | Supplier | Inbound Qty | Supplier | Inbound Qty | Outbound Qty
Vessel A | 1/1/2012 | Supplier A | 2000 | Supplier B | 2500 | 4500
Vessel A | 5/3/2012 | Supplier A | 3000 | Supplier A | 3000 | 3000

Your help would be greatly appreciated