Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2009
    Location
    Google, KS
    Posts
    47

    Unanswered: having trouble with subreport binding to report using date field?

    I am trying to build a report using a distinct query of date, then I have added 4 subreports that are built using 4 more queries that also use the =[enter date]
    how should i bind the subreports so that when i enter a date in the report it pulls the data in the subreports using that same date?
    Life - sexually transmitted, always fatal.

    My beer drunken soul is sadder than all the dead christmas trees in the world.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You can either delete the criteria from the subreport queries and use the Master/Child links of the subreport control, or have the user enter the date onto a form and have all the queries get the date from there.
    Paul

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I might suggest a form where you enter the dates on the form and use that as criteria in your subform queries (ie. = Forms!MyReportForm!StartDate or Between Forms!MyReportForm!StartDate and Forms!MyReportForm!EndDate.) Then you can re-use this same form again and again for other reports.


    There are a few examples in the code bank.

    http://www.dbforums.com/6274791-post21.html
    http://www.dbforums.com/6282462-post36.html
    http://www.dbforums.com/6304815-post55.html
    Last edited by pkstormy; 11-21-09 at 23:12.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Nov 2009
    Location
    Google, KS
    Posts
    47
    Hey thanks for all the help so far.

    I ended up having the user enter a date onto a form then had all the queries get the date from the form. I currently have it set to pull just one date.

    pkstormy, those examples were pretty awesome but my skills are not, so I had no idea how to incorporate them into my database.
    Life - sexually transmitted, always fatal.

    My beer drunken soul is sadder than all the dead christmas trees in the world.

Posting Permissions

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