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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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