kenny.willems
Member
Hi everyone,
i have a little problem and I can't figure it out, maybe you can help me.
in my table I have following records
Art Clr Type Date Time Value
100 25 A 1/1/08 10:30 8
100 25 A 1/1/08 10:25 9
100 30 A 1/1/08 10:29 5
100 30 A 1/1/08 10:21 6
i need following the last modified record for art / clr / type, so the result must be:
100 25 A 1/1/08 10:30 8
100 30 A 1/1/08 10:29 5
thx in advance
i have a little problem and I can't figure it out, maybe you can help me.
in my table I have following records
Art Clr Type Date Time Value
100 25 A 1/1/08 10:30 8
100 25 A 1/1/08 10:25 9
100 30 A 1/1/08 10:29 5
100 30 A 1/1/08 10:21 6
i need following the last modified record for art / clr / type, so the result must be:
100 25 A 1/1/08 10:30 8
100 30 A 1/1/08 10:29 5
thx in advance