Re: Removing duplicate records

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Peter (czupet_at_wsinc.com)
Date: 03/14/04 

Date: Sun, 14 Mar 2004 11:43:07 -0600

So if I have the following record set how do I select first record?

Score Gender
80 Male
80 Male
80 Male

Thanks

"Kevin Yu [MSFT]" <v-kevy@online.microsoft.com> wrote in message
news:d6vUMLOCEHA.1672@cpmsftngxa06.phx.gbl...
> Hi Peter,
>
> The syntax for the filter is just like the criteria in SQL statement after
> 'WHERE' clause. Here is an example.
>
> dsXml.Tables[0].Select("Score>80 and Gender='Male'");
>
> If anything is unclear, please feel free to reply to the post.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>

Relevant Pages

  • Re: Create a Record Set, Then Update Table from Record Set
    ... if you run filtered update query - it will also run it on 3500 records only. ... I am not sure I understand your idea with recordset, but anyway - if you want to filter recordset - you can use .Filter property: ... Therefore running update queries against a record set means the sql ... > Dim rst as DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: ODBC VC6 CRecordset m_strFilter LIKE syntax?
    ... The syntax you would use for SQL Server is "CodiceGruppo LIKE '244671%'". ... Other DBMS's may use different characters for wildcards. ... > What I am trying to do is filter the record set for all records ...
    (microsoft.public.data.odbc)
  • Re: DAO Recordset
    ... > Can anyone tell me what is wrong with this syntax I am trying to use ... > to search a record set. ... You've got a variety of mismatched quotes. ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • DAO Recordset
    ... Can anyone tell me what is wrong with this syntax I am trying to use to ... search a record set. ... I keep getting data type mismatch... ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Macro error
    ... I have a macro to filter my data...it sorts the data ... You may be at the end of your record set" (which is ... but then it haults teh macro with a Action Failed ...
    (microsoft.public.access.macros)