Can this be done by creating a report...

[Airbiskit]

What I have is a database that holds info on people that have taken training courses with us. I would like to create a standard type letter that can be sent out to the clients informing them that their certification has expired.

Within the query I have included the account no, name of trainee, description of course and the expiry date.

The first page will be the standard type letter and the second would be a kind of booking form with the course info grouped by name of trainee, and the expiry date etc.

I have started by putting the letter into the Page Header and there is a Name Header containing the Trainee Names and Details section containing the Course Description and Expiry Dates.

The problem I have is that I cannot get the query info to appear on a new page all on its own. I would like the info to come in this order -

Page 1 - Letter
Page 2 - Candidate 1 Info
Page 3 - Letter
Page 4 - Candidate 2 Info
etc...

Can this be done and could you be kind enough to correct me were I am wrong.

Many Thanks

 

[dhookom]

Your table structure isn't clear. Are there possibly multiple trainees per account? I think you could do this by placing the trainee information in a subreport.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[THWatson]

Airbiskit
Try this...

Right click on the Name header and set the Force New Page property to "before section" and see if that does what you want.

See if that does what you want.

Tom

 

[THWatson]

Airbiskit
My suggestion was incorrect. I tried this and it works.

Put the Letter in the Group Header. Put the Candidate info in the Detail Section. Set the Detail properties to Force New Page "before section."

Also, in your Sorting and Grouping, set the Keep Together to "whole group."

But also take a look at Duane's reply, as you may want to do this with a subreport.

Good luck.

Tom

 

[Airbiskit]

There are multiple trainees for each account, but the query will run by choosing the Account and the Expiry date. I will work through your suggestions and thank you for the help

 

[Airbiskit]

Hi Tom,

Thanks for your advice, I have worked through your suggestion and I do kinda get the format of,

Page 1 - Letter
Page 2 - Candidate 1 Details
Page 3 - Letter
Page 4 - Candidate 2 Details

But i would like on the candidate details page to have it so the candidate's name appears once and if they have several courses that expire to appear underneath the name.

I do get the letter on each page correctly..Great!! I need help to get the grouping and sorting on the names so all the courses that expire in the period specified will appear on one page below the name.

Thanks for you help again Tom and Duane.

regards

Steve

 

[dhookom]

If you want to group by candidate name then add another sorting and grouping level on candidate name.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.