[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.

[khader82]

Hey waldos ..

Whenever u post any queries on this forums make sure u don use the resolved POST ICON (the green tick mark) the members wouldnt look at your problem at all...

coming to ur question..

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

if accept is string field use
query1 = "SELECT Count(AssessDetails.Quality) AS CountOfQuality From AssessDetails WHERE AssessDetails.Quality = '" & Accept & "'"

if accept is numeric field use

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

let me know if it works..