Re: DISTINCTROW doesn't yield off unique rows in one of my columns
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 14 Jul 2005 00:16:06 -0600
On Wed, 13 Jul 2005 18:56:01 -0700, "ishleepy tin c',)" <ishleepy tin
c',)@discussions.microsoft.com> wrote:
>Hi, I need a Filter1 column that gives out unique sets of characters but the
>DISTINCTROW command can't seem to be able to filter it fine, I'm still seeing
>multiple rows in Filter1 column having exactly the same set of characters.
Use DISTINCT instead of DISTINCTROW. DISTINCT looks only at the fields
in the SELECT clause; DISTINCTROW looks at all fields, selected or
not.
John W. Vinson[MVP]
.
- References:
- DISTINCTROW doesn't yield off unique rows in one of my columns
- From: ishleepy tin c',)
- DISTINCTROW doesn't yield off unique rows in one of my columns
- Prev by Date: Re: List Box
- Next by Date: Re: Subform not staying synchronized!
- Previous by thread: DISTINCTROW doesn't yield off unique rows in one of my columns
- Next by thread: Why does auto expand work in Win98 but not XP?
- Index(es):
