Separating sections in a report

[Wullie]

Hi,

I have a query which returns selected fields into a report in a schools
database.

At the moment, the report shows all the entries as one list (which is what I
would expect).

What I would like it to do is create a blank line (or a row with a header)
for each separate section (eg between list of primary and secondary schools).

Is this possible to do and if so, how?

Thanks

 

[Dale Fye]

Have you tried creating a group on the primary schools?

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Lord Kelvan]

ummm i think what dale is asking is do you have a field that
identifies which school is a primary school and which field is a
secondary school ie a school try field

eg
school name school type
school 1 primary
school 2 secondary
school 3 secondary
school 4 primary
etc...

 

[Wullie]

The fields are already split this way, I'm just not sure how to separate them
when I create the report template so that it would look

School 1 Primary
School 4 Primary

School 2 Secondary
School 3 Secondary

 

[Lord Kelvan]

ok well when you make a report use the wizard and you in that you can
do something called grouping

so then group on that type field and it will split them for you

you shouldnt try to add a blank line in a query mind you it is
possible using a three part union query but you shouldnt do that just
use the grouping function in the report

Regards
Kelvan

 

[Wullie]

Thanks, that sorted what I was after.

I had to redo the report that I had already created, which wasn't too much
hassle.

For future reference, is there a way that I could add a grouping split to an
already created report, or does it all come down to planning in advnace?

 

[Wullie]

It's OK, I found it myself - thanks again for your help