Record Source Order!

  • Thread starter Thread starter Bob V
  • Start date Start date
B

Bob V

Can I change the record source order so as it sorts descending because at
the moment the SrNo is ascending in the table........Thanks for any help
SELECT * FROM tblRemarks ORDER BY [SrNo];
 
Can I change the record source order so as it sorts descending because at
the moment the SrNo is ascending in the table........Thanks for any help
SELECT * FROM tblRemarks ORDER BY [SrNo];
Click to expand...

SELECT * FROM tblRemarks ORDER BY [SrNo] DESC;
 
Thanks Fred :))

fredg said:
Can I change the record source order so as it sorts descending because at
the moment the SrNo is ascending in the table........Thanks for any help
SELECT * FROM tblRemarks ORDER BY [SrNo];
Click to expand...

SELECT * FROM tblRemarks ORDER BY [SrNo] DESC;
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print only what is True! 2
Report Case by Dates 1
A Combo box doesn't fire event 6
Print order by Date 13
Change Report to show all records 1
Windows XP icon help 1
Records in between 2 dates 8
Change Order for a Report 2

Back
Top