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
