Re: Removing duplicate records

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 10:05:44 GMT

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: If statement question
    ... Change the WHERE clause in your SQL statement to look like: ... When you look at this in the design view, it should make sense to you. ... next to it where I put this in the criteria ...
    (microsoft.public.access.formscoding)
  • Re: Performance improvement in displaying records on a form
    ... Also index any fields that are part of the criteria or Where clause. ... I'm using a sql statement to set the recordsource for the form. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Not Exists joining 2 tables
    ... "'code' is a bad name for a key column" is a valid complaint. ... EXISTS clause with a correlated subquery properly, ... SQL+ syntax and start using the ANSI SQL syntax that seems ... Then the only criteria in the where clause ...
    (comp.databases.ms-sqlserver)
  • Re: Criteria linked to form combo Yes/No or All expression help
    ... The way I'd debug it would be to start w/ one OR clause in the criteria. ... Run the query & see if it works for that criteria. ... I followed your suggestion of pasting the sql, ...
    (microsoft.public.access.queries)
  • Re: How do you hide Columns in a SubForm
    ... RowSource, using a SQL statement, so i wouldn't be surprised that the ... Dim strSubformSQL As String, siteID As String ... the first thing i'd check would be the data type of the criteria fields. ...
    (microsoft.public.access.modulesdaovba)