I would like to create a report to be used as a register for a children's project. At the end of each day some of them stay on for an extra lesson and it would be very useful to keep track at a glance of who has a lesson on which night.

Each record includes the following fields:

Child's Name
Individual Lesson Day
Individual Lesson Time

I would like to create a seperate report for each day. For instance if it was Monday the report would be laid out as follows:

All Children where Lesson Day = Monday listed in alphabetical order by first name.

Then everyone else, listed in alphabetical order by sirname.

Obviously once I figure out how to do it for one day it will be very simple to create the other 4 reports.

This seems simple but Alas I do not yet have the skills to create it, or to articulate it well enough in search engine speak in order to find the solution.

Muchos gratitude to whoever can point me in the right direction.

Cheers,

Alan

sistemalan,

Take a look at the attached database. You did not indicate what version of Access you are using. The attached Db is in 2002 format.

It should do pretty much what you want.

Post back with any questions.

Hi Mr B,

You are a legend. This is just what I need, and thank you so much for taking the time to create an example database. Using 2003, so no bother opening it.

I hadn't yet figured out what sub reports were for. That was the missing link.

Many thanks,

Alan

Your welcome. Glad to help.

Good luck with your project.