***** 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.