instead to use and ... and a....and in sql

[sal21]

Instaded to use a variuos AND statement in a where condition on field TEST i can use the statement

... where TEST in (ttt,iii,iuy)...eccc

Tks.

[HansV]

where TEST in ('ttt','iii','iuy')

is the same as

WHERE TEST='ttt' OR TEST='iii' OR TEST='iuy'

For an AND condition, you have to use

WHERE ThisField='ttt' AND ThatField='iii' AND OtherField='iuy'

[sal21]

where TEST in ('ttt','iii','iuy')

is the same as

WHERE TEST='ttt' OR TEST='iii' OR TEST='iuy'

For an AND condition, you have to use

WHERE ThisField='ttt' AND ThatField='iii' AND OtherField='iuy'

OK... tks for note.

on fly... i need to update the filed MESE from DATA_CREAZ only with a month in format MM...

example:
DATA_CREAZ=12/12/2010 MESE=12

note:
DATA_CREAZ is formatted as Date MESE is Text
see the image vattached

[HansV]

You can update to

Format([DATA_CREAZ], "mm")

Note the quotes around the format strong "mm".

[sal21]

where TEST in ('ttt','iii','iuy')

is the same as

WHERE TEST='ttt' OR TEST='iii' OR TEST='iuy'

For an AND condition, you have to use

WHERE ThisField='ttt' AND ThatField='iii' AND OtherField='iuy'

... base the IN condition how to insert in Field1 the two condition:

Field1=" " or IsNull

[HansV]

You'd use

WHERE Field1=" " Or Field1 Is Null

(are you sure that you mean a space?)

[sal21]

You'd use

WHERE Field1=" " Or Field1 Is Null

(are you sure that you mean a space?)

YES!

During the rs(I) looping i se a var (refered the current record Var=" ")...

[sal21]

You'd use

WHERE Field1=" " Or Field1 Is Null

(are you sure that you mean a space?)

Based thi condition how to integrate the condition of field1 in existing SQL string?

SQL = "SELECT * FROM [CC_DAILY] WHERE [TIPO_DATO]='" & TEST_TIPO & "' AND COD_FIDO <> " & TEST_TIPO_CTR_2 & " AND CTR IN (" & TEST_TIPO_CTR & "," & TEST_TIPO_CTR_1 & ") AND INATT=" & INATTIVO & " ORDER BY COD_SPORT_RAD, COD_CONTO"

[HansV]

SQL = "SELECT * FROM [CC_DAILY] WHERE [TIPO_DATO]='" & TEST_TIPO & "' AND COD_FIDO <> " & TEST_TIPO_CTR_2 & " AND CTR IN (" & TEST_TIPO_CTR & "," & TEST_TIPO_CTR_1 & ") AND INATT=" & INATTIVO & " AND (Field1=" " Or Field1 Is Null) ORDER BY COD_SPORT_RAD, COD_CONTO"