Record Source Order!

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];
 
F

fredg

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];

SELECT * FROM tblRemarks ORDER BY [SrNo] DESC;
 
B

Bob V

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];

SELECT * FROM tblRemarks ORDER BY [SrNo] DESC;
 

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

Top