How can I place several page breaks in different locations in Access 2 1

[bobnplano]

I am using Access 2000 and have a created a database with names and addresses, i.e., Address Book, and established the report to print in the right places and the right font I want. However, I have not been able to find out how to place page breaks between each alphabetical letter or end of page. Can anyone help me with this? I would most appreciate it.

Thanks,

Bob

 

[Kelanen]

You either need to add a 'first letter' field to the table (very clunky but easy), or much better; in the query* that the report is running off create a temporary field:

expr1: Left([Name],1)

* If you don't already, you should always base reports from queries, not tables (even if you just dump the whole table into a query and run it from that). You get much more flexibility this way, and it's easier to always do this at the start, than change things later.

This will create a field containing the first character of your primary sort field (I've assumed 'Name' above - change as necessary).

In your report, go to the Sorting and Grouping function (it's the nested bracket icon that's displayed on the toolbar in Design view). Insert a line at the top of the S&G hierarchy for 'expr1' (or whatever you would like to call it), and sort on this in the normal way (ascending, presumably), and select 'Yes' for Group Footer.

Roll-up the expr1 footer, and clicking on the grey section seperator, go to properties->all. At the attribute 'Force New Page' select 'After Section'

Done!

I'm not sure what your Access ability is like, so forgive me if I've over-simplified or complicated the instructions. If you need any more help, let me know. Jonathan Challis
IT Manager

 

[Kelanen]

btw - there are a number of Access forums that would probaly have got this answered faster for you... Jonathan Challis
IT Manager