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 :-)
"Wayne-I-M" wrote:
> 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
>
>
> --
> Wayne
> Manchester, England.
> Enjoy whatever it is you do
>
>
> "1foxi" wrote:
>
> > 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.
> >
> > "Wayne-I-M" wrote:
> >
> > > 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
> > >
> > > --
> > > Wayne
> > > Manchester, England.
> > > Enjoy whatever it is you do
> > >
> > >
> > > "1foxi" wrote:
> > >
> > > > 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,