MS Access Report Force New Page

[camerobabe]

I've got a report with names, building number and room numbers. I have it sorted by name. I would like to have only the names beginning with 'a' on one page, then when a name begins with 'b' start a new page. I've tried grouping by name and setting the different force page options but don't get the desired result. I usually end up with just one name on each page. Any suggestions?

 

[scriverb]

If your report is populated by a table then we have to change that to a query. If you are using a query we just have to modify it.

In this query create a new column with the following code:
FirstChar: Left([LastName],1)

Now use this new field as the Sort and Grouping field to create the GroupHeader with the Force a New page option. It will be just the first character of the LastName field. So everytime it changes a new GroupHeader will trigger and a new Page will be initiated.

Let me know if you need more assistance on this. Bob Scriver

 

[camerobabe]

I tried what you suggested (instead os "LastName" the field is just "Name&quot. I get the error message "Function isn't available in expressions in query expression".

 

[scriverb]

Your system must have a MISSING Library reference. Open up a form in design view and click the code button. Select Tools / References and see if there is a Library reference marked as missing. If so you have to install that .dll to make the code work. Bob Scriver

 

[camerobabe]

The filter OLE control module says missing. Is that it?

 

[scriverb]

That is not one that I have active. It is not required for what I have given you I don't think. I have MS 8.0 Object Library and the DAO 3.51 Object Library as well as VB for Applications.

Bob Scriver