Can someone with more VBA ability than my humble self have a quick peek at this and tell me where I've mucked it up? The error message is below: (this is querying an Access database)
and the error message says there's a Syntax error (missing operator)
cat_dist and reliability_best_now are both numbers, the other two are both text
Code:
sql_st = "Select * FROM data Where cat_dist = " & dist & " AND where reliability_best_now = " & reliability & " AND where EP_THEN_FINAL_MARK = '" & form & "' AND where cat_fitness = '" & fitness & "'"
and the error message says there's a Syntax error (missing operator)
cat_dist and reliability_best_now are both numbers, the other two are both text