Count in a Report (revised question)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thank you for those that answered my first question, I think I may have
outlined what I wanted incorrectly. I need to list telephone directories by
zipcode. Since telephone directories contain more than 1 zipcode in coverage
and vise versa I need to know the total number of directories which cover a
certain zipcode.
Zipcode Directory Name
44907 Directory A
Directory B
Directory C
Total number of directories : 3
I then have to take the Total value and divide that by the number of
customers. Since customers have access to more than one directory, we are
going to divide the number among the directories in the area.

Sorry if I assumed wrong, and you did understand my problem. After I
reviewed it, I was confused by what I was tryiing to ask.
Thank you
-Frustrated with Access!
 
You have mentioned two new terms that haven't been identified: "customers"
and "area".

How do you expect anyone to provide assistance when we are aiming at an
undefined, moving target?
 
I just need to count the number of directories. I thought background info
would help clarify what I wanted to do and why I chose to count the
directories and not the zipcode. What I want to count has not changed.
I am sorry if the added terms did not make sense.
 
Maybe you need to provide a better sampling of records and desired output in
the report.
You have been asked to place a text box in the zipcode group footer with a
control source like:
=Count(*)
I assure you this will count the number of records for each zipcode group.
 
Thank you for your patience, I guess I'm having a hard time describing what I
have and what I want it to do. This is how the report is set up (I am not
including the labels) -

ZIP HEADER
Zip Clients
DETAIL
dir_name Bookcode state Price CostperClient
DIR_NAME FOOTER
=Count(*)
PAGE FOOTER

--------------------------------------------------------------------------
zip = is the zipcode
dir_name = name of telephone directory
Bookcode = numerical code for telephone directory
state = state the directory is in
clients = how many clients came from that zipcode
Price = advertising $ amount
CostperClient = need to divide the number of clients into the number of
directories and then that amount divided by the Price of the directory (not
sure how this will be done, since I do not have the directory count).

This is what I want as a result -

ZipCode 99999 Clients 6
Directory Name Bookcode State Price CostperClient
Directory A 111111 OH $1,000.00 $500.00
Directory B 222222 OH $ 200.00 $200.00
Directory C 333333 OH $ 300.00 $150.00
Total Directories: 3


Currently when I have =Count(*) in the dir_name Footer, the value placed
underneath each directory is 1.

Maybe I'm trying to do too much in the report, and should try to create a
query or table?

Thank you for your assitance.
 
Why are you create a dir_name footer? It seems I have suggested a couple
times to use a zipcode footer and place the Count(*) in it.
 
I still recieve the same result. When I have =Count(*) in the Zip Footer,
the value placed underneath each directory is 1.
 
What are your levels of sorting and grouping? Which display headers and/or
footers? Where is your =Count(*) text box?
 
What are your levels of sorting and grouping?
Through the report wizard, I grouped the Zip field and that was it.

Which display headers and/or footers?
The headers and footers are:
Report Header
Zip Header
Detail
Zip Footer (also have used dir_name)
Page Footer
Report Footer

Where is your =Count(*) text box.
I placed this in the Zip footer (dir_name footer too)

Everything but the Zip Footer is the same as previously indicated.

Do you have a favorite manual or book to help with Access? I've looked on
line, and there are several different types with varying price ranges.

Thanks
 
So, you are stating that if you place a text box in the Zip Footer with a
control source of: =Count(*), you are not displaying the number of records
present in that zip code?

I assume you are displaying the Directory information in the detail section.
 
Back
Top