Results 1 to 5 of 5
  1. #1
    gaby58 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    19

    How to create a Letter in Report

    Hi All,

    I have following fields in access table
    First Name, Laste Name, DOB. Content, SchoolName, Address, City, State and Zip.
    The content is same for all reports, but each school will have 1 to many student.
    The report should look like this

    School Name
    Address
    City
    State
    Zip

    Content



    First Name|Last Name|DOB


    The problem is if the School has more than one student then each student will get a different letter
    But what we want is if the School has multiple students, then their names and DOB should be in one letter only.
    I tried to use grouping on SchoolName, Address and all, but it is not working. Any other tips and ideas will be very helpful

    Thank You

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    yes, group on SchoolName,
    the detail group would be the students

    or master report for schoolname
    subReport for students

  3. #3
    gaby58 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    19
    I did grouping on Schoolname, Addres, City, State and Zip, but it is not appearing.

    Also if I create master report then where will I add the content, could you please give me some example for both types.

    Thank you so much

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    did you put School info in the School group?

    alt:
    master report gets the school data,
    subRpt gets student data, BUT BOUND TO MASTER FIELD

  5. #5
    gaby58 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    19
    When creating with Wizard, I added School name, address, City, State and Zip to grouping, but they are not appearing in the report

    Alt:
    What about Content, it is same for all the letters, will it go to School data?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 09-22-2020, 03:31 AM
  2. create a letter type report
    By sreejith0000 in forum Reports
    Replies: 2
    Last Post: 03-22-2017, 06:41 AM
  3. Report as Letter
    By blue_echo in forum Reports
    Replies: 1
    Last Post: 04-13-2016, 02:11 PM
  4. Replies: 4
    Last Post: 09-18-2012, 05:07 AM
  5. From letter from a report
    By LANCE in forum Reports
    Replies: 4
    Last Post: 07-04-2009, 09:32 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums