我有一个表象调查员,其中包括一个调查现场,显示名单。
补助金可能有1名以上调查员。
我的项目要求把所有调查员列入赠款细节旁边的单一牢房,这样,即:
Grant A | Name A, Name B, Name C etc.
我有一个VBA模块,将调查员召集到以下1个小组:
Concat Returns lists of items which are within a grouped field
Public Function c(strID As String, strAddMe As String) As String
Static prevID As String
Static strFinal As String
Static strLastAdded As String
If (strID = prevID And strAddMe <> strLastAdded) Then
strFinal = strFinal & ", " & strAddMe
Else
prevID = strID
strLastAdded = strAddMe
strFinal = strAddMe
End If
c = strFinal
End Function
还有一个称为“SQL”的出入问题:
SELECT g.grant_id, Max(c(g.grant_id,tblInvestigators.investigator)) AS Expr1
FROM tblGrants AS g LEFT JOIN tblInvestigators ON g.grant_id = tblInvestigators.grant_id
WHERE (((g.grant_id)=6))
GROUP BY g.grant_id;
在我进行这项工作时,它回到了一张 com子分离的清单,但它是一栏(蓝色调查者、调查者)的识别号清单。 我怎么能找到名字?
Chris