Results 1 to 2 of 2
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Problem with Report

    I am unsure as to why this report is telling that

    Property Pass Query_Expired does not exist when it is clearly a query

    The first query in the report is

    Property Pass Query_Current

    and it works.

    The second query is



    Property Pass Query_Expired

    and it does not work.



    I am unsure why. The query is there but the error when I try to open this report says it is not.


    I used subreports on each query (three subreports for three queries) and something
    went wrong.

    Any help appreciated. Thanks in advance.

    Respectfully,


    Lou_Reed



    The
    Attached Files Attached Files

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Attachment 24723
    You can't have queries as the subreport. They have to be reports to be subreports. See attached.

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

Similar Threads

  1. Report problem
    By army182 in forum Access
    Replies: 2
    Last Post: 05-14-2014, 10:25 AM
  2. Problem with a report
    By renegp55 in forum Reports
    Replies: 3
    Last Post: 05-18-2012, 01:34 PM
  3. Report Problem
    By access_man in forum Access
    Replies: 7
    Last Post: 11-14-2010, 12:07 PM
  4. report problem
    By mann2x in forum Reports
    Replies: 1
    Last Post: 10-09-2010, 06:10 PM
  5. Problem with sub-report
    By samo1215 in forum Reports
    Replies: 0
    Last Post: 06-27-2010, 01:11 PM

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