I am connecting to an Access Database table in Python. There is something wrong with the IIF statement in my query when the condition is false it should find the greatest value between col7 and col8. If someone could point me in the right direction. Thanks!
Code:qry2=("select col1, col2, col3, col4, iif(col5 < 1 OR col6 IS NOT NULL, col7, MAX(col7, col8)) as testcoldata from mytable")