Hi there,

I'm having some problems with my SQL queries. When I query a row in my Access database, the values are 'null' value. Sometimes it returns the contents of the row field, other times 'null'. I don't want null values.

------------------------------------------------------------------------

partnercomparestring = "Select * From customers where customerid = " & Edit_Customers.Text24.Text & ""
rs3.Open partnercomparestring, adoConnection, adOpenForwardOnly, adLockOptimistic

If Edit_Customers.Text17.Text = rs3.Fields(15) Then 'partner title
partnerredflag = partnerredflag + 1
End If

'--------------------------------------------------------------------

In this case, rs3.fields(15) will return 'null' value. It should return "" if it has an empty value. My other queries run fine and I have tries adopting the same structure but to no avail.

Thanks in advance

Simon