Query not working 1

[SiJohn101]

I keep getting this error message

Microsoft VBScript compilation error '800a0409'

Unterminated string constant

/tpv/test3.asp, line 11

strSQL1 = "SELECT * FROM tblPRICEBANDS, tblCOTTAGES WHERE tblPRICEBANDS.fldPRICEBAND = tblCOTTAGES.fldPRICEBAND AND tblPRICEBANDS.fldPRICEBAND = " & strPRICEBAND AND tblCOTTAGES.fldPROP_NO = " & strPROP_NO

However if i put anything on the end it just brings up more error messages what is the best way to the end the query????

 

[amorous]

Try this:

strSQL1 = "SELECT * FROM tblPRICEBANDS, tblCOTTAGES WHERE tblPRICEBANDS.fldPRICEBAND = tblCOTTAGES.fldPRICEBAND AND tblPRICEBANDS.fldPRICEBAND = '" & strPRICEBAND & "' AND tblCOTTAGES.fldPROP_NO = ' " & strPROP_NO &" '

OR

strSQL1 = "SELECT * FROM tblPRICEBANDS, tblCOTTAGES WHERE tblPRICEBANDS.fldPRICEBAND = tblCOTTAGES.fldPRICEBAND AND tblPRICEBANDS.fldPRICEBAND = '" & strPRICEBAND & "' AND tblCOTTAGES.fldPROP_NO = " & strPROP_NO

-VJ