How do you write a query to bucket all values in one column that share the same value in the another column in the same table?

Question

Good Morning everyone!

This will be a freebie for those experienced developers. I have a table with only two columns in it. A Part Number column and an ATA code column.

There are Part Numbers that share the same ATA code. Or to word it in a different way. Multiple part numbers may have the same ATA code as there are revisions to Parts so they are issued new part numbers.

What I would like to accomplish is to make a query to list all of those Part Numbers under Each of their associated ATA codes.

Almost like a nested look somehow. Similar to a pivot table in excel.

ATA Code

PN1

PN2

PN3

ATA Code

PN1

Answer 1

It is not easy to do that in a query. You can design a report for this purpose; perhaps the easiest way is to use the Report Wizard. Tell the wizard to group the report by ATA Code.

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

Time for you to laugh. The only way I know how to make reports is by having a query opened already. And then I make the report from that way.

Answer 3

Got it! Thanks!