Help creating a report

[d00ku]

I have 2 tables, Students and Attend.

Students consists of a StudentID and StudentName.
Attend has StudentID, AttDate and AttType.

I have set up a query that shows me all students who have an AttType greater than 0. (0=attended, 1=sick, 2=ua, 3=a and 4=holiday).

I want to create a report that shows all dates on one page for each student.
At the moment I can only create a report for each day they are off, so for example I have a report that shows John Smith being sick on the 27/07/03 and then another page that shows him being off sick on the 28/07/03 too.

If anyone can get their head around that I would be thankful for any feedback.

Thanks

 

[MattS]

Sounds like you need to add some sorting/grouping in your report. If you sort it by StudentID then AttDate, add a footer for StudentID.

Go to the properties for the new StudentID footer, and set Force New Page = After Section.

This should force a page break at each change in StudentID.

 

[d00ku]

Sorry I don't think I explained myself properly...

Each day a person is off a new record is created.

For example, John Smith could have 11 different records.
What I want to do is create a report that looks like the attatched jpg I created in word.

Thanks for your reply anyhow.

 

[Rich]

Have you tried the Report wizard?

 

[d00ku]

Yes, the report wizard will make a report with a different page for each day of absence, so in that jpg example, I would have 11 different pages in my report.

I have tried creating a crosstab query to make a report on but I cant seem to get it to work.

 

[Rich]

Reduce the height of each section to the minimum

 

[d00ku]

Reducing the size of each section would not create the desired report.

 

[MattS]

What you want to achive is entirely possible using sorting/grouping and headers/footers within the report. The attached db is very basic, but I think does what you want.

HTH,

Matt.

 

[d00ku]

Thanks a lot Matt, it worked a treat, when I tried from your directions in your previous post I couldnt get it to work.

Thanks once again, your help is much appreciated.