Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Between 2 dates

Discussion in 'Information Technology' started by Jamie, Jul 28, 2006.

Tags:
  1. Jamie

    Jamie
    Expand Collapse
    Guest

    I have a report set up with multiple subreports inside. I would like the user
    to be able to enter in a start date and an end date and for the report to
    show data only from that time period. Because I have multiple subreports when
    I ask for a start and end date the database requires the user to enter a date
    for each subreport. I only want them to have to enter in a date once. Any
    suggestions.
     
  2. Loading...

    Similar Threads Forum Date
    How Did Sikh Heritage Become Hostage To Hostilities Between India And Pakistan? Hard Talk Jun 26, 2016
    Is There A Thin Line Between Love And Hate? Interfaith Dialogues Apr 25, 2016
    what happened in between Blogs Oct 16, 2015
    Sikh Marriage Between Man & Woman Sikh Sikhi Sikhism Jul 1, 2015
    Difference between us and the Gurus? Sikh Sikhi Sikhism Dec 25, 2014

  3. Jeff C

    Jeff C
    Expand Collapse
    Guest

    Assuming you have a text box on your form for each date, go to the query you
    are using as the record source for your form/report and in the date criteria
    field:

    Between [forms]![Myform]![txtboxbegin] AND [forms]![Myform]![txtboxend]
    --
    Jeff C
    Live Well .. Be Happy In All You Do


    "Jamie" wrote:

    > I have a report set up with multiple subreports inside. I would like the user
    > to be able to enter in a start date and an end date and for the report to
    > show data only from that time period. Because I have multiple subreports when
    > I ask for a start and end date the database requires the user to enter a date
    > for each subreport. I only want them to have to enter in a date once. Any
    > suggestions.
     

Share This Page