Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012

    Unanswered: How to create a calculation in a report?


    I'm trying to create report that will have calculated values based on the number of returned records for a query. The query returns records based on the date, so the number of records returned will change day to day. The calculations in the report should reflect the fluctuating number of records in the query. Hopefully that makes sense.

    So in the report, I have a text box with the Control Source:


    Access seems to like the context okay (no error messages in Design View), but I get an error when I go to Report View. Is there some other way I should be telling it to count the number of records in the query? Is there something wrong with the syntax?


  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    As suggested elsewhere, try

    =13.2+4.4*DCount("*", "[QueryName]")

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts