Morning All,
I have the following sql statement which although is selecting a few fields it is still relativley simple
It is because i inserted the firstname & ' ' & surname line that i am getting the error "Operator equals boolean AND, type equals varchar at execute reader" ???Code:Me.SqlSelectCommand1.CommandText = "SELECT Quotations.[Enquiry Number], Quotations.Price, Quotations.NeworRecon AS Co" & _ "ndition, Quotations.QuoteValidity, Quotations.InstallationPeriod, Quotations.Ext" & _ "ension, Quotations.StairliftType, Quotations.FirstName, Quotations.Surname, Quot" & _ "ations.QuoteRequested, Quotations.QuoteSent, Appointments.TITLE, Appointments.IN" & _ "ITIAL, Appointments.NAME, Appointments.ROAD, Appointments.VILLAGE, Appointments." & _ "TOWN, Appointments.COUNTY, Appointments.POSTCODE, Appointments.[ENQUIRY NUMBER]" & _ ", Quotations.ID, Quotations.Quantity, Quotations.Make AS Make, Quotations.Model," & _ " Quotations.Platform AS Platform, Quotations.Automatic AS Automatic, Quotations." & _ "Hinge AS Hinge, Quotations.Joint AS Joint, Appointments.TITLE & ' ' & Appointments.NAME FROM Quotations INNER JOIN Appointments ON Quotations.[E" & _ "nquiry Number] = Appointments.[ENQUIRY NUMBER] WHERE (Quotations.QuoteRequested" & _ " = 1) AND (Quotations.QuoteSent = 0)"
Does anyone know what is going wrong in this pls?




Reply With Quote