Results 1 to 5 of 5
  1. #1
    balajigade is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Mar 2014
    Posts
    30

    Summary Report

    In access 2010 summary report footer I want to find out no of instances where Field-1=0 and Field-2 > 70


    I tried the following expressions :

    =DCount("[Field-1]","ReportName","[Field-2]=70" And "[Field-1] > 0") This is just giving total nos of records in the report , not filtered

    =DCount("[Field-1]","ReportName","[Field-2]"=70 And "[Field-1]" > 0") This is giving #Type error


    Pl suggest a solution

  2. #2
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Code:
    =DCount("[Field-1]","ReportName","[Field-2]=70 And [Field-1] > 0")
    You should avoid using special characters (space, dash, etc.) in object names.

  3. #3
    balajigade is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Mar 2014
    Posts
    30
    Yes I know. Used spaces, capitals, special characters only in the post to improve readability. Actual field names are different. However showing #Error again.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Is reportname a table? If not, I don't think you can use the name of your report as a domain parameter. It has to be a table or query (set of records).
    If you are trying to get the count from the report fields, try a calculated control in a group footer/header or report footer with the desired running sum property.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    balajigade is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Mar 2014
    Posts
    30
    The I've used the 'reportname' (which is same for the report & the query in question) against domain name for an expression in another text box in the same report and is working fine. Lemme try other alternatives.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Summary Query in Report
    By chris.williams in forum Queries
    Replies: 3
    Last Post: 07-17-2013, 11:33 AM
  2. Creat a Summary Report
    By Karenclaire in forum Reports
    Replies: 3
    Last Post: 04-23-2013, 06:27 AM
  3. Order Summary Report
    By ryonker in forum Reports
    Replies: 1
    Last Post: 01-10-2011, 09:15 PM
  4. Replies: 2
    Last Post: 08-25-2010, 01:42 PM
  5. Summary Report Help Please?
    By solitaire in forum Reports
    Replies: 3
    Last Post: 03-03-2006, 08:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums