columns in a report

[Guest]

On my database i record a list of students who are Year 1, year 2, Year etc.
My table is: Year, Firstname, Surname etc

I want to create a report that will group all the year 1s together, year
twos and year threes together. But I want it to group them so that the
report is in colums eg

Year 1 Year 2 Year 3
Names Follow Names Follow Names Follow

Can you help?

Thanks,

 

[Guest]

Hi

I think there may be a better of doing this (but I can't find it). I trick
I have used in the past is to set to report to half half, third, quater, etc
of a page width and then use the columns option in the page setup to what I
needed.

Oh and make sure you don't use the page header option (use the report header
instead) unless you want the header to be a the top of each column.

Hope this helps

 

[Guest]

Thanks for that. That did kind of work. But the report doesnt look any
good, and if I sit and mess with it and get it right, as soon as I delete a
record its going to mess the whole thing up again.

is there a rule or something so i can say, in columns 1 & 2 i want Year 1
students, Colums 3 &4, year 2 students etc

thanks for your help.

 

[Guest]

Hi

try this link - it looks a bit over the top to start with but I just tried
it and it is quesy after you get the basic idea

http://support.microsoft.com/kb/812719/en-us

 

[Guest]

Thanks for the link. I got as far as typing all the text in the onclick
event. After that Im totally lost. Im fairly new to Access so the rest of
the instructions looked a bit too confusing