Quote:
|
Have you considered using min and max, instead of first and last? First and last depends on position in the file; min and max doesn't care.
|
Well, min(value) would give me the actual minimum value for each ID rather than the earliest (in time) value...
min(Date) works for giving me the earliest date..but then how would I get the value associated with that date? hmmmm
That is of course without those huge ugly queries already suggested.. There must be a better way....
Thanks for all your thoughts so far
