求助,求助,字段1 字段2 字段3
aaa 111 2222
aaa 112 3333
. . .
. . .
bbb 111 1234
bbb 112 2145
. . .
. . .
这个表如何显示为
字段1 字段2 字段3
aaa 111 2222
112 3333
. .
. .
bbb 111 1234
112 2145
. .
. .
aaa 111 2222
aaa 112 3333
. . .
. . .
bbb 111 1234
bbb 112 2145
. . .
. . .
这个表如何显示为
字段1 字段2 字段3
aaa 111 2222
112 3333
. .
. .
bbb 111 1234
112 2145
. .
. .
Select
iif((Select Count(字段1) From 表1 Where 字段1=A.字段1) As C1>1,"",A.字段1) As 字段1,
A.字段2,A.字段3
From 表1 A
Private strnn As String在Detail_Format()里写入如下代码
strn = ""
If strnn = "" Then
strnn = Trim(Field1)
Field1 = strnn
Else
If strnn = Trim(Field1) Then
Field1 = ""
Else
strnn = Trim(Field1)
Label1 = strnn
End If
End If
这样就能实现了