Search results

  1. J

    Reports

    Thx for your response: I was able to create a field that counts the yes and no's..ex---Count PrecallNo: Count(IIf([Reviwshttable]![Precall]=1,1,Null)). I'm also able to go into the report and sum the count total. My problem is when I try to calculate the percentage of the count (in the Report...
  2. J

    Reports

    The Rookie: Can I sum records in a report and then use the total in a simple calculation in the same report. Ex. I'm summing the count of records of yes and no's in query and then I'm trying to take this sum two produce a percentage. I keep getting the #Error. Any help is appreciated.
  3. J

    Count all records in a query?

    Just tried your formula and it was on the money!! Thanks
  4. J

    Count all records in a query?

    I tried to trick the null data because when I run the original count query all null data comes back as zero. Obviously, that didn't work and it still returned zero. SELECT Reviwshttable.[ID], Reviwshttable.[Claimnum], Reviwshttable.[Precall], Count(Reviwshttable.Precall) AS CountOfPrecall...
  5. J

    Count all records in a query?

    How do I count all records in a query to include null values?
Back
Top Bottom