I have just been asked to split an access report by the building field, so that when the report prints out each buildings data is on a seperate sheet of paper, is there an easy way of doing this or will i hyave to create a query for each building.

In design view of the report go to View Then Sorting and Grouping. Group by the building field.

Then go to Properties select the header of the building field. Force new page after.

Ok thanks for that, that would of worked but what i neglected to say was! the database has a field with the building name in and a room number next to it, instead of being split into 2 seperate fields,so it would print a room on each sheet rather than the building, the only way i can see is to do a query on each building and the rooms.

Or create two fields. One for the building and another for the Room. This would be a better design. eg You should never have a field of Name. you should have FirstName and LastName as seperate fields.


PS Name is a reserved word and should never be used.

Is there anyway i can split a field within a table, so i can put the data into another table.With this field having both building and room number in one field it would save me to actually split the field and import the data into another table, then i could put each building on a seperate page, from a report.