Hi everyone,

I use the data grid to display the records from a sybase database. The problem is the user has 1000's of records to display, which takes a lot of time.

They want to see only the last few day's transactions.

How can I set up the Adodc control to display only the last 10 reocrds or only last few days records?

How can I set up the record source of the Adodc control, some thing like this,

Select * from tblInvoice where Trx_date between today and 5 days before today.

or

Select only the last 10 records from tblInvoice.


Any help is greatly appreciated.

Thank you.

sincerely,
rathi