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];
Click to expand...

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];
Click to expand...

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