[RESOLVED] Syntax Error

[waldos]

I am trying to count the number of records in Field Quality that are Accept with

query1 = "SELECT Count(AssessDetails.Quality) AS CountOfQuality From AssessDetails WHERE AssessDetails.Quality = " & Accept
                                        or this                  = " Accept"
                                        or this                  = ("Accept")"

but keep getting Syntax error.

How do I write it.
Help appreciated & Thanks in Advance.