[windows2000] Re: OT: MS Access - Generating multi-columnreport
- From: "Andrew Shriner" <aShriner@xxxxxxxx>
- To: <windows2000@xxxxxxxxxxxxx>
- Date: Mon, 17 May 2004 15:35:05 -0400
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
Other related posts:
- » [windows2000] Re: OT: MS Access - Generating multi-columnreport
