group with commas 1

[hellohello1]

How can I make data that looks like this:

ProjectID......Descr..........................Category
2005.............No Prior Years..............Cost
2005.............Unfunded Need..............Cost
2005.............Missing total..................Cost
2012.............[blank]..........................[blank]
2043.............Cost Var>15%...............Cost
2043.............Underrun .......................Cost
2043.............No storage.....................Org
2056.............Date in past..................Sched
2056.............Date mismatch.............Sched


Into data that looks like this:
ProjectID................Cost.......................................................................Org............................Schedule
2005.....................No Prior Years, Unfunded Need, Missing Total............[blank]........................[blank]
2012.....................[blank]....................................................................[blank].......................[blank]
2043.....................Cost Var>15%, Underrun.........................................No storage.................[blank]
2056.....................[blank]....................................................................[blank].......................Date in past, Date mismatch


I tried a crosstab query with Category for the Column and for the Value, typed: Expr1: First([Descr]) & " ," & Last([Descr]). But I can only do First and/or Last. But what if there are 3 or more values that need to be displayed, such as in ProjectID: 2005 above.

Thanks,

 

[dhookom]

Try this faq701-4233.

Duane
Hook'D on Access
MS Access MVP

 

[hellohello1]

You are absolutely the best. It works perfectly.

Thank you so much!