Help with SQl syntax for select statement.

[compucop]

Hi, I upsized my access database to a ADP, one of my reports does not recognize the below SQL statement. anybody know the correct syntax ? Thanks.

rs4.Open "SELECT * FROM TABLE WHERE TABLEID =" & INTTABLE & " AND TABLEYESNO = FALSE", cn4, adOpenStatic

 

[chiph]

 SELECT * 
 FROM TABLE 
 WHERE TABLEID =" & INTTABLE & "
   AND TABLEYESNO = FALSE

My first guess would be to check what datatype the upsizing wizard made column TABLEYESNO. And then verify that that datatype can contain values of "FALSE".

Chip H.

 

[compucop]

upsizing wizard changed format to yesno, but I changed it to true/false. I still get an error with the above statement. Thanks for your time Chip.

 

[compucop]

GOT IT... Use 0 for True and 1 for False, unbelievable huh.