You'll have to get creative. <g> I usually concatenate the PK into the 3rd column so I can find my way back to the original record. It's a little hinky because any and all displays will use SUBSTR() to mask out the PK, but it works well.

Dan



>>Sounds like a job for a crosstab.
>>
>>SELECT WEEK(DateField), DOW(DateField), SomeOtherField ;
>> ORDER BY 1,2 INTO CURSOR PreXtab
>>DO (_genxtab)
>>BROWSE
>
>EDIT: Given that I've never used crosstabs *AND* that my test data was as clear as mud... Yes, this looks like where I need to start. How can I go from the crosstab result back to the original record?
>
>Chris.