Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007

    Unanswered: Report: Titles for counted groups

    I have a report that is grouped by zip code. I need to show the city name (label) along with the count total for the group. For example:

    total records of 44863 (Newark) = 2 shows Newark 2
    total records of 44870 (Lorain) = 5 shows Lorain 5

    Does anyone know how this can be done.


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    you would need a lookup table that identifies what zip code (or what element of the zip code identifies what city/georaphical area

    you could pull the city name into the group footer either through the main query or through using a dlookup or soem other mechanism.

    the easiest is probably to modify the query that is providing the source for the report.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts