UtterAccess Discussion Forums > Mutilple Columbs in a report

Full Version: Mutilple Columbs in a report

UtterAccess Discussion Forums > Microsoft® Access > Access Reports

turk645

Jan 8 2008, 04:23 PM

Ok i need to make a report based on who is getting what awards. The tables are all set up and the report is the only thing puzzling me. Is it possable to Group people by award and have the names show up in different columbs? Somethign like this....

CODE

                                       Award Name
       FirstName LastName          FirstName LastName           FirstName LastName
       FirstName LastName          FirstName LastName           FirstName LastName
       FirstName LastName          FirstName LastName           FirstName LastName

Larry Larsen

Jan 8 2008, 04:29 PM

Hi
Have you looked whilst in the report module at;
File > Page Setup > Columns..(set the amount of columns needed)

freakazeud

Jan 8 2008, 04:33 PM

In Acc2007 that would be Report Design--Page Setup Tab (of the Report Design Tools tabs)--Page Setup button (of the Page Layout group)--Columns...
Or press the columns button in the Page Layout group to directly get to the screen.
HTH
Good luck

Larry Larsen

Jan 8 2008, 04:39 PM

Darn.. Oli didn't notice the access version..
( the sooner we colour code these versions the better..lol)

turk645

Jan 8 2008, 04:50 PM

Well it would work normaly but the grouping is messing things up and i need the grouping so the report will expand easily if new awards are added.

turk645

Jan 8 2008, 06:34 PM

the problem is that it seams to be trying to trying to continue from what was on the bottom on the second row, itsnot actually columing the data the way i want.

turk645

Jan 9 2008, 08:21 AM

Still no solution to this because the grouping messes up the columns and i need the grouping instead of indevidual reports so things automaticly update if more awards are added. Maybe this small edit to the wording of the first post will make it a little more clear.

CODE

                                       Award Group
       FirstName LastName          FirstName LastName           FirstName LastName
       FirstName LastName          FirstName LastName           FirstName LastName
       FirstName LastName          FirstName LastName           FirstName LastName

                                       Award Group
       FirstName LastName          FirstName LastName           FirstName LastName
       FirstName LastName          FirstName LastName           FirstName LastName
       FirstName LastName          FirstName LastName           FirstName LastName

mike60smart

Jan 9 2008, 02:20 PM

Hi
This is the nearest I can get it

Mike

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.