DISTINCTROW 2

[BNPMike]

I have a table which is an intersection entity ie it links two other tables. I was interested in seeing how many of one of the linked datatypes there was so I added DISTINCTROW to a query that only had the relevant field. The query returned all records despite the fact that many of the rows displayed were identical.

Help returned no matching entries for Distinct or Distinctrow. I found this on Microssoft:

http://support.microsoft.com/default.aspx?scid=kb;en-us;207761

It says this

NOTE: Using DISTINCTROW in a query has no effect unless the query contains two or more joined tables

Does that sound right to you? Has this caused you problems in the past?

 

[hymn]

I always use Select Distinct which as far as I know works

Hope this helps
Hymn

 

[BNPMike]

You seem to be absolutely right...

 

[deeno]

Perfect timing... thanks!!!