how can use distinct cluase in Access Report Query ?
I use distinct cluase in the query but it ask vdate,
I want that it not ask vdata just display result
with distinct vdate how?


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


regards.

Mateen

Hi Mateen,

DISTINCT is a SQL keyword that would be used like:

SELECT DISTINCT [dbo_pvideo].[vdate], [dbo_pvideo].[userid], etc., etc..

though I doubt that will get you the results you're looking for (though I'm not really clear on what results you're looking for).

It appears that what you may want to do is GROUP BY the date in the report. But again, not sure...

Bob

thanks.

it is ok.

regards.

Mateen