QBF Probs - minor progress

[fraser_lindsay]

I have managed to get my QBF form to work with one fixed parameter. here is an section of the code:

where = Null
where = where & " AND [Noise]>=50 "


'[HAVS]>=50 OR [Skin]>=50 OR [Respiratory]>=50 OR [Biological]>=50 "



If Not IsNull(Me.[cboCategory]) Then
where = where & " AND [Category] = " & Me.[cboCategory]
End If


I can report any records with a score for [Noise] equal to or over 50 and by specific locatiosn etc using the QBF combos.

I want to be able to interrogate via a number of fields in addition to [Noise] using the OR function. The criteria being 50 for each one. Show me records for people if they have one or more over 50.

I can't get the code to work. If I add more to the string above the QBF part stops working and I get every name in my DB.

What am I doing wrong? (I indented my code attempt, it's not currently part of the string)

 

[fraser_lindsay]

where = where & " AND (([Noise]>=50) OR ([HAVS]>=50) OR ([Skin]>=50) OR ([Respiratory]>=50) OR ([Biological]>=50)) "


Cracked it! Messed about with it and copied the SQL code from a query in design mode. Seems to work, just needed more brackets.