Student Query

[jbento]

Hi to all my Tek-Tip friends:

I hope someone can help me with this one. I have a table (checkoutTable) in Access 2000, that I also built a query for. There are fields within that table for studentName and DateBookCheckedOut. I would like to associate the query to a Report, that will show the Student and all books that are checked out, but I want each student with their identified books checkout on their own separate page. Example: Student A has 3 books checked out. Student B has 4 books checked out.

I want Student A to have his/her own page that shows all of his/her books checked out.
I want Student B to have his/her own page that shows all of his/her books checked out.

Is there a page break that would be needed on the report for this? Do I create a parameter in the query for the StudentName and DateBookCheckedOut, or is there some code I need to do all of this?

Can someone please help me with this? Again, all of your help and assistance is GREATLY appreciated. I thank you all

 

[Databaseguy]

1.In you report, turn on the sorting and grouping button(It's the funny looking blue button in between the toolbox and wizard buttons)

2.Select the field you want to keep on a page under field/expression and add it to the grouping button.
In your case, it will be student.

3. Down at the bottom, there is "group properties". Select Group header and choose Yes. Your report now has a group header. Place your student textbox there.

4.In the same area, there is a "Keep Together", Select WholeGroup.

5. Put the books the student checked out in the detail section, not the header.

 

[jbento]

DatabaseGuy,
I tried it and I can't get it to work. I followed your instructions. Should I put the field name (studentName) in the Student Name Header, or do I just put a caption in their, like Student Name? Note: I still have the page break in the detail section, along with the other fields in this table. Should I delete the page break? I tried deleting it, and it just puts all students on the same page. Do I need to delete all parameter queries I previously set up, out of the query table, that this report is assigned to? Can you please advise me more? Thanks.

Jerome

 

[Databaseguy]

The textbox StudentName should go in the student name header. You can put a label in there to if you want, but the studentName field has to be up there.

Get rid of the page break.

Hope this helps.

 

[Databaseguy]

OK. One additional thing.

Right click on the student header. There is a ForceNewPage property. Set this to Before Section.

That should do the trick !

 

[jbento]

DatabaseGuy,
YOU ARE DA MAN. The ForceNewPage property worked BEAUTIFULLY!!! I thank you, thank you, thank you. Now my wife won't beat me up. It's her database. She is a 4th grade school teacher.

Jerome