This is very unclear, and probably very incorrect.
is this a field in a query, or a field in a report?
doesn't this give a syntax error, where-ever you use it. It looks definitely unsyntactical.
I assume calls is a number around .04 (strange name for a number, one should expect something like duration).
For a query, write something as
Select count(*) from mytable where calls < .04 and you'll get one record with one field, which is the answer. This is called SQL (Structured Query Language).
For a detailed report with a totals line:
- add a calculated field with value 1 to the query (if condition is met, otherwise 0)
- subtotal this calculated field in the totals line, giving the number of records in the detail section reported in the total line
This is a typical Access way of making a report.
It's time maybe to pay some consultancy fee to an Access programmer to help you in the right direction by making one or two example queries and reports?
Created a query to build my report to display all calls that came in. I have built my formula to count calls. Now I want to create a second formula to count all calls under 60 minutes. I have converted the time into a general number.
This is what I have tried:
iif([calls]<=0.0409722, count([calls]), 0)