Code:
VHANDICAP = rs("HANDICAP")
strSQL = "SELECT MAX(AMOUNT) FROM TABLE WHERE VHANDI= " & VHANDICAP & "'"
Debug.Print strSQL
rs.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
kindly help me to correct the error
VHANDICAP = rs("HANDICAP")
strSQL = "SELECT MAX(AMOUNT) FROM TABLE WHERE VHANDI= " & VHANDICAP & "'"
Debug.Print strSQL
rs.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
strSQL = "SELECT MAX(AMOUNT) FROM TABLE WHERE VHANDI= '" & VHANDICAP & "'"
Select max(amount) from table where vhandicap=''
select * from table where vhandicap=''
Comment