I use following query in Access report.
when I run this query it return right order by as I want.
ie
ORDER BY [dbo_pvideo].[userid], [dbo_pvideo].[vdate] DESC;

but when I use same this query in Access Report
it order by vdate desc not work
it display vdate asc order why ?

I want to order by userid, and vdate should be DESC order how ?



SELECT [dbo_pvideo].[userid], [dbo_pvideo].[vdate], [dbo_pvideo].[video1], [dbo_pvideo].[video2],
FROM dbo_pvideo
WHERE ((([dbo_pvideo].[video1]) Is Not Null))
ORDER BY [dbo_pvideo].[userid], [dbo_pvideo].[vdate] DESC;

what changing in access report ?
regards.

Mateen

Hi Mateen

Find Sorting and Groupin tool in Formatting toolbar
Set Field/Expression userid Sort Order Ascending and vdate Descending

-vemaju

Hi Vemaju,

Thanks.