No I didn't, but I honestly haven't had a lot of time to work on it since I sent the message asking for help... while I've been bored at work, I'm not able to work on it most of the time while here for various reasons. <sigh> I also found a flaw in the way the database was originally designed... now I need to go read up on pivot tables, and I'll probably wind up chaning some of the DB structure. Thanks, though. ----- Andrew (Drew) L Shriner Computer Support Services Eastland-Fairfield Career & Technical Schools (614) 836-5714 ashriner@xxxxxxxx >>> windows2000-bounce@xxxxxxxxxxxxx 05/17/04 11:51AM >>> Did you ever get this working Drew? Greg -----Original Message----- From: windows2000-bounce@xxxxxxxxxxxxx [mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Drew S Sent: Thursday, May 13, 2004 2:54 AM To: windows2000@xxxxxxxxxxxxx Subject: [windows2000] OT: MS Access - Generating multi-column report I have a relational database that will eventually track student goals for a high school. There's a query in it, and it pulls the data for a given report. I exported the query's results to a table, as I can't release the entire database publicly. That way I can show what I need help with: I'm trying to create a report that uses 2 columns. I've read the help system, I've read a couple of websites, I can't get it to work. I'm sure I'm doing something stupid incorrectly, but for the life of me, I have no idea what it is I'm doing wrong. Across the page header, I have the name of a class, and the student's name. I'm told that the page header spans the entire page, and doesn't affect columns at all. Good. I have a group header, that has the category for a competency listed, and then each competency is listed under 'detail'. I need that group header and detail view to utilize two columns, going down one column, and then back up to the second column. I've done everything I know how to do, and I have no idea what I'm overlooking. Could anyone take a peek at the database and make any suggestions? Thanks! There's a copy of the database that I'm working on, along with the troublesome report, at http://www.geekdrew.net/content/temp/test.mdb. Thanks! Drew ******************************************************** This Weeks Sponsor StressedPuppy.com Games Feeling stressed out? Check out our games to relieve your stress. http://www.StressedPuppy.com ******************************************************** To Unsubscribe, set digest or vacation mode or view archives use the below link. http://thethin.net/win2000list.cfm ******************************************************** This Weeks Sponsor StressedPuppy.com Games Feeling stressed out? Check out our games to relieve your stress. http://www.StressedPuppy.com ******************************************************** To Unsubscribe, set digest or vacation mode or view archives use the below link. http://thethin.net/win2000list.cfm ******************************************************** This Weeks Sponsor StressedPuppy.com Games Feeling stressed out? Check out our games to relieve your stress. http://www.StressedPuppy.com ******************************************************** To Unsubscribe, set digest or vacation mode or view archives use the below link. http://thethin.net/win2000list.cfm