I have a report which counts values on a table in which it is grouped by a value on that table and I want to count specific ranges with in that table and show the numbers on the report. My instructor told me to use

=Select count (select *
from [table]
where [req]=Yes
and [comp]=0
and ((Now()-[arrivaldate])/30.4)>=0
and ((Now()-[arrivaldate])/30.4)<=4
and [status]="UNQAL")

But I am getting this error
"the syntax of the subquery in this expression is incorrect"
"Check the subquery's syntax and enclose the subquery in parentheses"

Anyone help clean this up?