We have a database of customers which amongst others includes schools.
We want to send a letter to all schools (who are identified by customertype = 27) to ask them to let us know when they will be closed for the school holidays.
Each school has a varying number of departments, which are identified by a code (cc). Each code is unique to each dept of each school.
There are about 350 schools and over 1000 depts.
Each dept may have different closing times, hence including them on the letter.
I have have produced a report which lists each school one per page with the departments listed beneath in a single column.
The trouble is, some schools have over 30 depts which means that the column goes onto a 2nd page. This is a terrible waste of paper and looks very amateurish.
Can anyone tell me how to have the dept code (cc) either go horizontally across the page or in columns?
I've checked previous posts but nothing seems to work.
There was one on 12th April 2001 by natesin which seems closest but I can't get the query to work from within a report even as an SQL statement.
Please help!
We want to send a letter to all schools (who are identified by customertype = 27) to ask them to let us know when they will be closed for the school holidays.
Each school has a varying number of departments, which are identified by a code (cc). Each code is unique to each dept of each school.
There are about 350 schools and over 1000 depts.
Each dept may have different closing times, hence including them on the letter.
I have have produced a report which lists each school one per page with the departments listed beneath in a single column.
The trouble is, some schools have over 30 depts which means that the column goes onto a 2nd page. This is a terrible waste of paper and looks very amateurish.
Can anyone tell me how to have the dept code (cc) either go horizontally across the page or in columns?
I've checked previous posts but nothing seems to work.
There was one on 12th April 2001 by natesin which seems closest but I can't get the query to work from within a report even as an SQL statement.
Please help!