You may write a function like :
Function concat(firstime As Boolean, val As String, sep As String) As String
Static Concatstr As String
Concatstr = IIf(firstime, "", IIf(Concatstr = "", val, Concatstr + sep +
val))
concat = Concatstr
End Function
And use a query like : SELECT First(concat(True,[Name],"")) AS Expr2,
Last(concat(False, [Name]," / ")) AS Names FROM ....
This is the easiest (a bit too quick) solution.
The other solution goes thru a specific function development.
Eric.
> -----Message d'origine-----
> De : [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]De la part de
> [EMAIL PROTECTED]
> Envoy� : jeudi 19 avril 2001 13:15
> � : [EMAIL PROTECTED]
> Objet : MI-L CAI Database Problem
>
>
> 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
>
>
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
