Bill Downall wrote:
James,
Something like this can be done with some complicated SQL, but the easy
way to do it is with a crosstab report. do you always have one and only
one compliance value for each combination of fk_id and year?
Yes
Is compliance a text value?
Yes, instead of a number it can be a code such as n/a, c/s,d/r, ...
Bill, where are MIN-Max set?
(I suspect so, because of the left alignment.)
If it is text, and there is only one you can use a MIN or MAX function
in the crosstab specification. If it's integer, you can use SUM or AVG.
(If there is only one, the sum or the average are both the same as the
value.)
Look in the help for the topic "Designing Crosstab Reports."
______________________________________________________________
fk_id current_year(2005) current-1(2004) current-2(2003)
185 100 100 97
186 98 97 96
187 98 78 56
-----------------------------------------------------------------
