-

   rss_sql_ru_access_programming

 - e-mail

 

 -

 LiveInternet.ru:
: 16.03.2006
:
:
: 4

:


.

, 18 2014 . 18:10 +
!

:
( 255 ) :


+
Public Function makeID()
Dim s, db As DAO.Database
Set db = CurrentDb
db.Execute "delete * from FamUnion"
s = "INSERT INTO FamUnion (_) Select DISTINCT _ FROM _"
db.Execute s
makeID = True
End Function


c SQL
+
UPDATE _ INNER JOIN (_ INNER JOIN FamUnion ON _._ = FamUnion._) ON _._ = _._ SET FamUnion.Fam = (FamUnion.Fam+", ") & _._
WHERE (((makeID())<>False));


FamUnion Fam _ .

:
1. ?
)
) -
2. - , , 123 FamUnion Fam?

, !

http://www.sql.ru/forum/1111308/zapusk-zaprosa-i-vyvod-rezultata


: [1] []
 

:
: 

: ( )

:

  URL