Jump to content
Sign in to follow this  
netcode

Create list style report

Recommended Posts

Hey all,

I am looking at creating a list style report that shows the company names of contacts within my database. company name is a field in the contacts table. I only want it to list the company name once, not every occurrence of the company name.

I have created a summary field with the options count of the field "ID" (there is always a value if the record exists) when sorted by "Company Name". However this returns just a count of the records it seems (1, 2, 3, 4....etc) it doesn't seem to be counting the amount of records per company name like i thought it would

Any help is appreciated. Thanks

Looks like I have a report with appropriate numbers by each company, but the thing is there are large chunks of blank white space (assuming this is a record with no data in the company name field). But if that is the case, why isn't it grouping all that blank white space into one field and providing a number for the amount of records that have nothing in that field?

There are like 40 pages of blank on them :)

Edited by Guest

Share this post


Link to post
Share on other sites

Create a sub-summary report by Company Name.

Share this post


Link to post
Share on other sites

just edited again with an update, read above if you don't mind :)

Omg all I needed to do was delete the BODY part!

Edited by Guest

Share this post


Link to post
Share on other sites

you don't need a summary field unless you're counting the # of contacts for each company. Yes, no body part, unless you're listing the contacts under the company sub-summary part.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.