Showin Last 12 records

[hafizfarooq]

I have a table having TDate, TCode, Bill, Rcvd fields and 100 records
I want to show last 12 records of a particular TCode in CR 8.5
Please help me
Farooq

[szlamany]

Maybe something like this:

Where TCode in (Select Top 12 TCode From... Order by TCode Desc)