Ask VB to write a between and statement to query from a certain value to a certain value.

Used to query date-type values''It is used to query the value of the character, if it is a numeric type, then nothing is added, and pay attention to the trim function.

For example, if the field type is character-based, the SQL statement should be:

scp = "Field name between'" & trim( &"' and '" & trim( &"'"

Plus"#"It's a date, not a number.

scp="Field name between" & trim( &" and " & trim(

The date is only required in access

scp = "Field name between" & " and " & " "

scp = "Field name between" & " and " &

That's it.

= select * from Reimbursement Document Registration Form where Date Between Side"& Bi Qi refers to the date of hand-matching"

& in the middle of the object, leave a space to try.

s="select l1,l2,l3,l4 from [table name] where"Cracked Sky.

s=s & l1>" a & or "

s=s & l2> is blind" &a & or "

s=s & Ashima l3>" a

SQL query: Kaiye.

set = adodc1

dim rs as new

dim sql

provider=;persist security info=false;user id=**password=**data source=**

sql = select column name from table name where condition Zen next to Sun"Greeting chains.

set rs = exesql(sql)

sql

Different data can be found in different ways; The purpose of the search is different for different programming languages.

What are you looking for?

Literally, the ** on the first floor is the same as the landlord.,It is estimated that the landlord's actual ** has more spaces due to hand errors and other reasons:'" & a & " 'Here you should pay attention to the fact that there should be no spaces between single and double quotation marks, and ensure that there are no spaces when entering text, or when assigning values, you should deal with a=trim(.

Hope it helps.