Need Help in One to Many Relationship

• harshalnag

  SSC Enthusiast

  Points: 110

  More actions

  March 31, 2010 at 8:53 am

  #100718

  Hi,

  I have a table Structure

  filename AKA

  12-3-09.pdf 443567

  12-3-09.pdf 345678

  12-3-09.pdf 456789

  3-3-10.pdf 78901

  filename AKA

  I want to output as 12-3-09.pdf 443567,345678,456789

  3-3-10.pdf 78901.

  Any Help would be appreciated

  Thanks!

• sylvain.kusters

  Newbie

  Points: 5

  More actions

  April 2, 2010 at 12:11 pm

  #1145016

  Hi if you post also your table's and there structure maybe someone can help you

• Koncentrix

  Old Hand

  Points: 338

  More actions

  April 17, 2010 at 8:25 am

  #1153333

  Given you are using MS Access.

  You can achieve the output by writing 2 querries...

  1. query with the distinct filename

  2. using crosstab with the filename col and AKA code being transposed

  You can then inner joined the 2 querries on filename.

  Thank you and Hope this helps...

  Koncentrix

  Koncentrix