OK maybe I need to take a step back and give you some more detail.
Or maybe I'm just not going to comprehend what you guys are telling me.
I have a single table called assessment with these fields.
[assessment_id] [int] IDENTITY(1,1) NOT NULL
[youth_id] [varchar](26) NOT NULL
[org_id] [varchar](26) NOT NULL
[Taken] [datetime] NOT NULL
[assessment_type] [int] NOT NULL
Ive tried any number of answers from googling, and Ive been on this all day
and I simply don't follow what your doing. But this is what I'm after.
I'm only going to display 3 years so
#Year(dateadd("yyyy",-2,now()))# Through #year(now())#
but the part i get lost at is creating the empty cells for the values that
Don't exist.
-------------------2005--2006--2007--Total
------------------------------------------
assessment_type 1-----0-----5----10-----15
assessment_type 2-----3-----0----11-----14
assessment_type 3-----5-----5-----9-----19
------------------------------------------
Grand Totals----------8----10----30-----48
I really appreciate all the help but you would think their was an easy way
to do this with SQL. Seems it would be something you would need rather
often. What I keep coming up with is the following table with the type
repeated if theirs more than one year.
-------------------2005--2006--2007--Total
------------------------------------------
assessment_type 1-----------5----10-----15
assessment_type 2-----3----------11-----14
assessment_type 3-----5------------------5
assessment_type 3-----------5------------5
assessment_type 3-----------------9------9
------------------------------------------
Grand Totals----------8----10----30-----48
----Totally Confused----
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288668
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
