***** To join INSNA, visit http://www.insna.org ***** You can get it via SQL query in Access... Assuming there is a table (affiliations) that have two columns/fields (groupID,legislatorID), where each row indicates that a certain interest group made a donation for the corresponding legislator, then to get your one mode network the query will be select A.legislatorID,B.legislatorID, count(*) as weight from affiliations as A inner join affiliations as B on A.groupID=B.groupID where A.legislatorID<B.legislatorID group by A.legislatorID,B.legislatorID; The above query will result in edges between legislators with weight field indicating the number of donations received by both legislators by the same interest group. Best Regards, --- Hossam S. Sharara PhD Student LINQs Group University of Maryland - College Park http://www.cs.umd.edu/~hossam On Mon, Jul 26, 2010 at 2:32 PM, Scott McClurg <[log in to unmask]> wrote: > ***** To join INSNA, visit http://www.insna.org ***** I have two-mode > network data (legislators and interest groups, 435 and thousands > respectively) that I'm trying to convert into one mode data. Basically, all > I'm looking for are the number of common links between legislators where > links are defined as donations from the same interest group. We've failed > thus far to get this task done in Acess and we do not have the requisite > skills to write our own computer code. Has anyone run into a similar > problem and how have you solved it? Any advice would be welcome. > > -- > > Scott D. McClurg > Associate Professor of Political Science > PN-L Moderator > Department of Political Science > Southern Illinois University > Mailcode 4501 > Carbondale, IL 62901 > > (e) [log in to unmask] > (p) 618.453.3191 > _____________________________________________________________________ > SOCNET is a service of INSNA, the professional association for social > network researchers (http://www.insna.org). To unsubscribe, send an email > message to [log in to unmask] containing the line UNSUBSCRIBE SOCNET > in the body of the message. _____________________________________________________________________ SOCNET is a service of INSNA, the professional association for social network researchers (http://www.insna.org). To unsubscribe, send an email message to [log in to unmask] containing the line UNSUBSCRIBE SOCNET in the body of the message.