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?
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?
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.
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.
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.
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%.
Thank you
I have ID number in my database.
How i can print 100 students per sheet?
What i shoud write>
Thanks
Answer the other questions, please.
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.