Listers,
I am trying to formulate an Access query to
do the following to a CallingAreaInfo database.
Take this structure that looks like this:
201295 23
201295 45
202546 77
202546 85
202546 23
202645 15
And change it using a query to one that summarizes
like this:
201295 23 45
202546 77 85 23
202645 15
Does anyone have enough experience in Access to know
how I might go about this? Basically each NPANXX is
associated with an ID. My problem is, I need
each NPANXX to have several columns next to it with
IDs. Right now, I have repeating NPANXXs every time
a unique ID is linked.
Thanks,
Jonathan
