1) Data Record Filter: SQL = "SELECT * FROM Datasheet WHERE Field Name = Field Value ORDER BY Field Name" SQL = "SELECT * FROM DATA WHERE Field Name LIKE% Field Value% Order BY Field Name [DESC ] "SQL =" SELECT TOP 10 * FROM Datasheet WHERE Field Name ORDER BY Field Name [DESC] "SQL =" SELECT * FROM DATA WHERE Field Name in (Value 1, Value 2, Value 3) "SQL =" SELECT * FROM Datasheet WHERE Field Name BetWeen Value 1 AND Value 2 "(2) Update Data Record: SQL =" Update Datasheet Set Field Name = Field Value WHERE Condition Expression "SQL =" Update Datasheet Set Field 1 = Value 1 , Field 2 = value 2 ... field n = value N where condition expression "(3) Delete data record: SQL =" delete from data table where condition express "SQL =" delete from data table " Recording Delete) (4) Add Data Recording: SQL = "Insert INTO Data Table (Field 1, Field 2, Field 3 ...) Valuess (Value 1, Value 2, Value 3 ...)" SQL = "Insert Into Target Data Table Select * FROM source data table (add a record of the source data table to the target data table) (5) Data logging statistics: AVG (field name) draws a table column average count (* | field name) number of data lines Statistics or Values Values Value Value Max (Field Name) get the maximum value of the maximum value of a table bar to get the smallest value SUM (field name) plus the value of the data bar in a table column. Reference Method for the above function: SQL = "SELECT SUM (field name) AS alias from Datasheet Where WHERE Condition Expression" SET RS = Conn.Excute (SQL) Using RS ("Alias", other functions apply Ibid. (5) Establishment and deletion of data sheet: CREATE TABLE DATA Name (Field 1 Type 1 (Length), Field 2 Type 2 (Length) ...) Example: Create Table Tab01 (Name Varchar (50), DateTime Default NOW ))
