New to Access - Multiple rows/records into 1 row & several columns - HELP!

[weslake77]

Hi all,
I'm very new to Access. I have the following query:

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

[June7]

Arranging records horizontally can get very tricky. If a crosstab can't accomplish, VBA is likely required. Review:

http://forums.aspfree.com/microsoft-...ry-322123.html

http://allenbrowne.com/func-concat.html