Results 1 to 8 of 8
  1. #1
    handsomealso is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2013
    Posts
    16

    Print certain number

    Good Morning

    I design New database for school
    In this database I enter all students name.

    My Question: How do I print a report where a certain number of students, such as 100 students per sheet?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    If your tables are structured correctly, you can create a query that will display this. You can set the criteria you want directly in the query. After you view the results you need, you can decide to apply the WHERE criteria in the query, or report, or form, etc.

  3. #3
    handsomealso is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2013
    Posts
    16
    Thank You

    But What i shoud write in a query?
    In case I have 1000 students in my database, I want divide this students in group 100 in group A and 100 in group B...etc.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    If you want to assign students to a group you can add another column to the table that describes the student, probably the table that has the student ID, First Name, etc. In this new column you can place a value for each record/student that represents a group. You can assign a group once there is a field to distinguish the group.

    You can run an update query. I would probably use some VBA to loop through all of the records and update them. Then, have some code that would assign a group # every time a new student is added to the table.

    If you just want to run a report that has 100 per page, you could probably manage that using the report's On Format event handler.

  5. #5
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    1) Are these groups of 100 to be permanent groups, or can they change?
    2) Do you want them to be exactly 100, or exactly 10% of the total, or just about 100 and about 10% otf the total?
    3) Do the students have ID numbers?

    If you don't need exact counts, and if the students have ID numbers that are sequential or effectively random, then you can divide the students by (for example) the next-to-the-last digit of their ID number into ten groups. For example, if they have a nine-digit numeric ID number called StudID, then Substr(StudID,8,1) is one digit from 0 to 9, and will divide the students into groups of approximately 10% of the database. You can also use the "Top" SQL keyword to limit it to exactly 100 out of that 10%.

  6. #6
    handsomealso is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2013
    Posts
    16
    Thank you

    I have ID number in my database.

    How i can print 100 students per sheet?
    What i shoud write>

    Thanks

  7. #7
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    Answer the other questions, please.

  8. #8
    handsomealso is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2013
    Posts
    16
    1) Are these groups of 100 to be permanent groups, or can they change?
    In My database I didn't divide it in group.

    2) Do you want them to be exactly 100, or exactly 10% of the total, or just about 100 and about 10% otf the total?
    I would like to only 100 students in each report.

    3) Do the students have ID numbers?
    Yes, there is.

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

Similar Threads

  1. Embed Invoice Print within Statement Print
    By EddieN1 in forum Reports
    Replies: 2
    Last Post: 11-16-2013, 10:38 PM
  2. How to print receipt with auto number
    By jalals in forum Programming
    Replies: 1
    Last Post: 04-05-2013, 06:46 AM
  3. Replies: 1
    Last Post: 12-03-2012, 03:15 PM
  4. Replies: 5
    Last Post: 10-26-2011, 02:59 PM
  5. Replies: 0
    Last Post: 02-22-2011, 05:04 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