ashwinrao.k23 (8/10/2012)
thanks for the Reply!If i use Aggregate functions then its eating some of my data fileds. For MAX its giving only maximim valuse of available filds..
not quite sure what data fields are being "eaten"....maybe if you provide a script of the table....in the format that rVadim set out above, with a representative sample of data that demonstrates your problem (and expected results please)...then I am sure someone will be able to help
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day