I created a database that has positions and companies on the same page. There are multiple positions for each company, thus when I run a report to access company information, it pulls up the same info multiple times. For example, the City of Brea has 10 positions. The company information is the same for all 10. Lets say I need to make an e-mail address listing. So when I run a report (layout), it lists the e-mail 10 times for Brea when I only need it once. I understand that I could have two seperate databases, one for the companies and one for the positions, but that is what I initially did and that created many other problems. Does anyone know how to write in the script something that will omit the mulitple names that are brought up when I run the report? Thanks [email protected] [color:"green"]

I'll bet the "many other problems" of two files would go away with some proper design. You can collapse out duplicate information by using subsummary parts in your reports.

-bd