gt;
> Regards,
> Chris
>
>
> -Original Message-
> From: Richard Dillman [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 17, 2007 8:13 PM
> To: CF-Talk
> Subject: Re: Pivot table confusion
>
> OK maybe I need to take a step back and give you some mor
don't exist. Let me know if you
have any questions.
Regards,
Chris
-Original Message-
From: Richard Dillman [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 8:13 PM
To: CF-Talk
Subject: Re: Pivot table confusion
OK maybe I need to take a step back and give you some
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](
, and you will have your data across the entire range.
~Brad
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 11:33 AM
To: CF-Talk
Subject: RE: Pivot table confusion
Do you have an example of what you mean? Maybe I've been staring at i
Do you have an example of what you mean? Maybe I've been staring at it
too
long but i just don't see how to populate non existent data.
==
Yeah, here's a VERY quick example. It doesn't involve a pivot table,
but it shows what I mean by getting around missing v
I assume you're doing a or on the query results
directly, as you said you don't know the year is 'til you output.
One way might be to create a structure, loop over your query results and
populate the structure as you go - then you can look at that structure
and see where the gaps are (based o
Do you have an example of what you mean? Maybe I've been staring at it too
long but i just don't see how to populate non existent data.
On 9/17/07, Brad Wood <[EMAIL PROTECTED]> wrote:
>
> I've always solved that problem by looping over each year I want to
> output, then use a query of queries to
I've always solved that problem by looping over each year I want to
output, then use a query of queries to extract the data for that year
(if it even exists) and output it. Then you don't have any gaps.
There's probably a better way though. That's just my quick and dirty
method. :)
~Brad
8 matches
Mail list logo