|
|
Posted by ApexData on 04/26/06 03:06
Thanks for the response.
I took your advice and tried the following code:
SELECT IIf([RPR]=True,"RPR",
IIf([MNT]=True,"MNT",
IIf([BAT]=True,"BAT","Unknown"))) AS GroupByThis,
[RPR],
[BAT],
[MNT],
*
FROM [T-SERVICE];
The repairs have grouped just fine, but the battery and maint will only
group with records that are not already displayed in the repairs group.
Any further advice?
Navigation:
[Reply to this message]
|