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
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?
=Select count (select *
from
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?
