Counting records in group in Details view

H

HarryZ

Hello,

I'm a newbie to Access, so please be patient if I say something
spectacularly stoopid...

I'm using Access 2003. My data is in a small Excel table (~ 100 rows).
What I want to do is produce a very simple report that shows a count
the number of records in a group. For example, using 'zipcode' as my
data, I want a count of the number of records for each zip code.
Something like this (where '12345' and '23345' are zip codes):

12345 10
23345 5

I've searched the online help and found a way to display this data in
the Group Footer section of the report. (Access Help Topic: Count the
number of records in each group or report ). I tried this, and I get
something like this:

<several blank lines>
<divider line>
<repeat for number of identical entries in group>
12345 10
<several blank lines>
<divider line>
<repeat for number of identical entries in group>
22345 5

How do I get this data to show up without all the blank lines and
divider lines?

Thanks in advance,

Harry Z.
 
A

Allen Browne

One solution would be to select the Detail section in report design (i.e.
click on the gray horizontal bar labelled Detail), and choose Properties.
Set its Visible property to No (Format tab.)

A better solution would to be to use a Totals query.
Create a query using your attached Excel 'table.'
Depress the Total button on the toolbar.
(Access adds a Total row to the query design grid.)
In the Total row under zipcode, accept Group By
In the Total row under the primary key field, choose Count.
You can then make a report based on this query.
 
H

HarryZ

Aloha Allen.

Your suggestion to set the Visible property of the the Detail section
to 'No' worked perfectly! Mahalo nui loa (Thank you very much)

Harry Z.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top