bobunknown
Registered User.
- Local time
- Today, 07:23
- Joined
- May 25, 2018
- Messages
- 77
Hi all,
I have a table with numerous records in a access table in the following format:
The table records information relating to the collection of bins (exciting stuff). What I need is to find a way to place all the information from Bin_Size_ID right, on one row. So that it would look like so:
Dose anyone know a good method? I have looked in to pivot tables in Access and Excel but had little success. The end goal is to have the information mail merged in to a series of letters, one for each business, hence why they need to all be on one row (unless im wrong about that)
Any help anyone could provide will be much appreciated.
I have a table with numerous records in a access table in the following format:
Debtor_AC_No | PIM_No | Trade_Name | Premessis_Type | Bin ID | Bin_Size_ID | Emptying Cost | Bin Cost | CollectionNo | IndivCost | Rental Trade | Rental S2 |
---|---|---|---|---|---|---|---|---|---|---|---|
00177847 | PIM:01154 | The Bank | Trade - Bins | 979 | T 140 | £2.80 | £27.50 | 52 | £145.60 | £0 | £0 |
00001407 | PIM:00232 | YMCA | Schedule 2 - Bins | 602 | S2 360 | £4.50 | £55.00 | 52 | £234.00 | £0 | £0 |
00001407 | PIM:00232 | YMCA | Schedule 2 - Bins | 1005 | S2 360 | £4.50 | £55.00 | 52 | £234.00 | £0 | £0 |
00001724 | PIM:00218 | Short Break Service | Schedule 2 - Bins | 370 | S2 240 | £3.20 | £40.00 | 52 | £166.40 | £0 | £0 |
00006839 | PIM:00193 | Coronation Gardens | Trade - Bins | 263 | T 360 | £7.10 | £55.00 | 26 | £184.60 | £0 | £0 |
00007171 | PIM:00525 | Shajan Indian Restaurant | Trade - Bins | 613 | T 240 | £4.80 | £40.00 | 52 | £249.60 | £0 | £0 |
00007171 | PIM:00525 | Shajan Indian Restaurant | Trade - Bins | 614 | T 240 | £4.80 | £40.00 | 52 | £249.60 | £0 | £0 |
00007171 | PIM:00525 | Shajan Indian Restaurant | Trade - Bins | 615 | T 240 | £4.80 | £40.00 | 52 | £249.60 | £0 | £0 |
00007171 | PIM:00525 | Shajan Indian Restaurant | Trade - Bins | 616 | T 240 | £4.80 | £40.00 | 52 | £249.60 | £0 | £0 |
00007171 | PIM:00525 | Shajan Indian Restaurant | Trade - Bins | 617 | T 240 | £4.80 | £40.00 | 52 | £249.60 | £0 | £0 |
00007171 | PIM:00525 | Shajan Indian Restaurant | Trade - Bins | 969 | TR 1100 | £19.00 | £1.60 | 52 | £988.00 | £83.20 | £0 |
The table records information relating to the collection of bins (exciting stuff). What I need is to find a way to place all the information from Bin_Size_ID right, on one row. So that it would look like so:
Debtor_AC_No | PIM_No | Trade_Name | Premessis_Type | Bin ID | Bin_Size_ID | Emptying Cost | Bin Cost | CollectionNo | IndivCost | Rental Trade | Rental S2 | Bin_Size_ID1 | Emptying Cost1 | Bin Cost1 | CollectionNo1 | IndivCost1 | Rental Trade1 | Rental S21 |
1407 | PIM:00232 | Salvation Army | Schedule 2 - Bins | 602 | S2 360 | £4.50 | £55.00 | 52 | £234.00 | £0 | £0 | S2 360 | £4.50 | £55.00 | 52 | £234.00 | £0 | £0 |
Dose anyone know a good method? I have looked in to pivot tables in Access and Excel but had little success. The end goal is to have the information mail merged in to a series of letters, one for each business, hence why they need to all be on one row (unless im wrong about that)
Any help anyone could provide will be much appreciated.