Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    2

    Unanswered: Access Report Creating (with same adresses)

    Hello,

    I would like to create letters which show the total amount. ‘one’ address should be shown
    on ‘one’ letter, e.g. Street 1 has three members. A report should show the following:

    Members_Table

    Autonr First Name Adress Zip Place Amount
    1 A. Johnson Street 1 123456AB Detroit 200
    2 T. Peterson Street 21 123456CC Los Angeles 120
    3 P. James Street 13 123456GG Orlando 160
    4 R. Graham Street 61 123456YY New York 240
    5 P. Johnson Street 1 123456AB Detroit 100
    6 N. Carlson Street 23 123456TR Chicago 160
    7 D. Johnson Street 1 123456AB Detroit 200


    Letter 1

    A. Johnson Street 1 200
    P. Johnson Street 1 100
    D. Johnson Street 1 200
    +
    500

    Letter 2

    T. Peterson Street 21 120


    Letter 3
    Etc.


    Probably this has to be done via a query. I have a few things but since I’m still a beginner this is not that easy for me. Any help would be appreciated.

    Greetings, Jim

  2. #2
    Join Date
    Feb 2003
    Posts
    2

    Re: Access Report Creating (with same adresses)

    Can anybody help me with the beginning of my problem creating these reports?

    Jim

  3. #3
    Join Date
    Jul 2002
    Location
    Romania
    Posts
    122
    You could create the report using the wizard and select grouping by street...then add some page breaks after the group footers.

    Or, create the report manually and then insert grouping levels from View-Sorting and Grouping.

    Good luck

    Dan

Posting Permissions

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