One Item, Multiple Vendors

  • Thread starter Thread starter Nick.Steinhauer
  • Start date Start date
N

Nick.Steinhauer

I have a query question. I have a particular list of item numbers.
Some items have multiple vendors. I would like a report that creates
one row per item and lists Vendor 1 and Vendor 2. If there is a
second vendor, I would like that information displayed under the
Vendor 2 column. Right now I just have multiple lines per item if
there are two vendors. Any help is greatly appreciated. Links to
websites work fine as well.

Desired effect below...
| Article | Vendor 1 | Vendor 2 |
| 12345 | HRRM | ASHF |
| 34545 | JJFM | |

What I am getting now
Article | Vendor |
12345 | HRRM |
12345 | ASHF |
34545 | JJFM |
 
I have a query question. I have a particular list of item numbers.
Some items have multiple vendors. I would like a report that creates
one row per item and lists Vendor 1 and Vendor 2. If there is a
second vendor, I would like that information displayed under the
Vendor 2 column. Right now I just have multiple lines per item if
there are two vendors. Any help is greatly appreciated. Links to
websites work fine as well.

Desired effect below...
| Article | Vendor 1 | Vendor 2 |
| 12345 | HRRM | ASHF |
| 34545 | JJFM | |

What I am getting now
Article | Vendor |
12345 | HRRM |
12345 | ASHF |
34545 | JJFM |
Click to expand...

Create a Crosstab query, using the Article as the "row header" and the
Vendor as the "column header". Won't be exactly the same but it will
give you the same spreadsheet-like appearance.

John W. Vinson [MVP]
 
Back
Top