PC Review


Reply
Thread Tools Rate Thread

columns in a report

 
 
=?Utf-8?B?MWZveGk=?=
Guest
Posts: n/a
 
      13th Nov 2006
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,
 
Reply With Quote
 
 
 
 
=?Utf-8?B?V2F5bmUtSS1N?=
Guest
Posts: n/a
 
      13th Nov 2006
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,

 
Reply With Quote
 
=?Utf-8?B?MWZveGk=?=
Guest
Posts: n/a
 
      13th Nov 2006
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,

 
Reply With Quote
 
=?Utf-8?B?V2F5bmUtSS1N?=
Guest
Posts: n/a
 
      13th Nov 2006
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,

 
Reply With Quote
 
=?Utf-8?B?MWZveGk=?=
Guest
Posts: n/a
 
      14th Nov 2006
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,

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
display report title on a report with columns Karen Microsoft Access Reports 1 4th Mar 2010 11:30 PM
Columns in a report NEWER USER Microsoft Access Reports 1 15th Dec 2009 04:10 AM
Columns in report Rachel B. Microsoft Access Reports 8 7th Oct 2008 08:20 PM
Resize columns on report to match form and move columns left toremove gaps heidii Microsoft Access Reports 1 30th Apr 2008 07:50 PM
I need a report that has two columns, that each have two columns... Kelvin Beaton Microsoft Access Reports 6 9th Jun 2005 01:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:48 AM.