SoFunction
Updated on 2025-04-09

Use criteria for conditional query--1.5. Commonly used criteria expressions

Use criteria for conditional query--1.5. Commonly used criteria expressions

Updated: November 3, 2006 00:00:00 Author:

5. Commonly used criterion expressions If the data entered in the criteria is a date, Access will be automatically surrounded by #, and if it is text, it will be automatically surrounded by ". Here are some commonly used expression formats for reference: expression meaning Values ​​that meet the criteria Between #95-1-1# And #96-2-1# Between 95-1-1 and 96-2-1 95-5-1, 95-12-31 Not "Wang Xiaosha" No, Wang Xiaoshe Wang Yueliang, Zhang Meili >=10 Greater than or equal to 10 10.5, 11, 100 Year([transportation date])=1999 Shipping date is 1999, no matter what month or day 1999-1-10, 1999-12-31 Is Not Null Not empty "", 0, (or any value) Like "*country*" Any position of the string contains the word "country" Zhang Guoqing, Li Aiguo
  • use
  • Use it correctly
  • Guidelines
  • Then enter
  • conduct
  • Line
  • condition
  • Check
  • Query
  • Inquiry 1
  • 15
  • 5
  • Commonly used
  • Used
  • Accurate
  • Guidelines
  • Table
  • Express
  • Desert
  • Mode

Related Articles

  • Use criteria for conditional query--1.4. Select query conditions from form

    Use criteria for conditional query--1.4. Select the query conditions from the form...
    2006-11-11

  • Share the method of modifying the automatic numbered ID value to zero by ACCESS database

    This article introduces the method of modifying the automatic numbered ID value to zero in ACCESS database. Friends who need it can refer to it.
    2013-10-10

  • A summary of Access usage

    I recently helped a friend with a small project. I encountered some problems, and the records are as follows
    2010-02-02

  • Four ways to randomly obtain 10 pieces of data in four databases

    This article mainly introduces four methods to obtain 10 data at random in the database. Friends who need it can refer to it.
    2014-03-03

  • Escape characters about SQL statements in ACCESS

    Escape characters about SQL statements in ACCESS...
    2007-04-04

  • Access error solution for "No search keyword found in all records"

    I haven't noticed it after writing asp for so long, but today I actually encountered it. The web page is a modification submission of title and information content (remarks type). There is no problem with the first modification submission, but an error occurs when the second modification is submitted.
    2008-11-11

  • Analysis on the principle of SQL offset injection in Access data

    When there are many fields in the target data table and one by one, try to use offset injection to implement SQL injection. This article mainly introduces the principle analysis of SQL offset injection in Access data. Interested friends follow the editor to take a look.
    2024-06-06

  • Build a small access database record

    The biggest advantage of access is that it is simple and easy to learn! People who are not computer majors can also learn it. So using it as a primer to learn is a very good choice. This article mainly talks about how to build a small ACCESS database step by step
    2014-08-08

  • Chinese Access2000 Quick Tutorial--1.8 Define the Relationship between Tables

    Lecture 8: Defining the relationship between tables After defining the primary key and the corresponding table, you can formulate the relationship between each table part to establish a relational database. The application and management relationship database of Chinese Access2000 has strong capabilities, which is exactly what Chinese Visual FoxPro 6 and Chinese Excel 2000 are not as good as Chinese. In order to establish a relational database, you must first establish each related table, then close them all, and you can follow the following steps.
    2006-11-11

  • Access Methods for executing SQL

    How to execute Sql in Access? Although it reduces the workload with interfaces, I am still used to executing SQL.
    2009-06-06

Latest Comments